Backslash in data/query and like queries help needed

[Craig Stadler]

mySQL 4.0.20a WIN32

Need help with backslash syntax/like queries..

Query1:
select * from dbtable1 where Filespec like 'http://www.10291.com/%'
returns : http://www.10921.com/sikhnet/register.nsf/ram/radioG2/\$File

Query2:
select * from dbtable1 where Filespec
='http://www.10921.com/sikhnet/register.nsf/ram/radioG2/\$File'
returns 0 records

Query3:
select * from dbtable1 where Filespec like '%\\%';
returns 0 records

What am I missing here....?
Something really strange happens when a record has a backslash in it....
How is it I can run Query1 and not Query2, Query3...????
Feel free to also reply via email

cs********@hotmail.com
-Craig

[Craig Stadler]

> select * from dbtable1 where Filespec like 'http://www.10291.com/%'

Correction (i meant 10921) replaced for security/privacy reasons in original
message...
I think you get the idea though...

-Craig

"Craig Stadler" <cs********@hotmail.com> wrote in message
news:ic*********************@news.easynews.com...

mySQL 4.0.20a WIN32

Need help with backslash syntax/like queries..

Query1:
select * from dbtable1 where Filespec like 'http://www.10291.com/%'
returns : http://www.10921.com/sikhnet/register.nsf/ram/radioG2/\$File

Query2:
select * from dbtable1 where Filespec
='http://www.10921.com/sikhnet/register.nsf/ram/radioG2/\$File'
returns 0 records

Query3:
select * from dbtable1 where Filespec like '%\\%';
returns 0 records

What am I missing here....?
Something really strange happens when a record has a backslash in it....
How is it I can run Query1 and not Query2, Query3...????
Feel free to also reply via email

cs********@hotmail.com
-Craig