Hello,
I created a MYISAM table named 'TBLTest',
there is a field named 'value', varchar(32) binary,
I insert value in it with a backlash as 'test\ABC',
I can search the record by : value='test\\ABC',
but I cannot search it by : value like '%test\\ABC%'.
The SQL:
1,create the table:
create table TBLTest(
value varchar(32) binary)
)
2,insert a record:
insert into TBLTest values('test\\ABC')
3,the SQL which can find the record just I inserted:
select * from TBLTest where value='test\\ABC'
4,the SQL which CANNOT find the record:
select * from TBLTest where value like '%test\\ABC%'
5,the SQL which CANNOT find the record:
select * from TBLTest where value like '%\\%'
Is it a bug or just MySQL designed as that.
I am not good at English,I am very sorry if this
letter is diffcult for you to read.
Thank you very much.
_________________________________________________________
Do You Yahoo!?
银行巨头聚会中原 大浪淘‘金’谁将笑傲
http://sweepstakes.yahoo.com/bank_surveywave2/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
