Hi all,
I have the following info in my database
ID | Name
1 | Author\'s
As you can see, the name value has been escaped. Now, the question is,
how do you match on a value that has escaped charaters? I've tried the
following
SELECT * FROM table WHERE Na
On Wed, Aug 13, 2003 at 09:23:38AM -0500, Jay Blanchard wrote:
> [snip]
>
> ID| Name
>
> 1 | Author\'s
>
> As you can see, the name value has been escaped. Now, the question is,
> how do you match on a value that has escaped charaters? I've tried the
> follo
On 13 Aug 2003 at 16:17, Rob wrote:
> ID| Name
>
> 1 | Author\'s
>
> As you can see, the name value has been escaped. Now, the question
> is, how do you match on a value that has escaped charaters? I've
> tried the following
>
> SELECT * FROM table WHERE Na
[snip]
ID | Name
1 | Author\'s
As you can see, the name value has been escaped. Now, the question is,
how do you match on a value that has escaped charaters? I've tried the
following
SELECT * FROM table WHERE Name = 'Author\'s'
SELECT * FROM table WHERE
