* xu tom > 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%'.
select * from TBLTest where value like '%test\\\\ABC%' This is in the manual: "To search for `\', specify it as `\\\\' (the backslashes are stripped once by the parser and another time when the pattern match is done, leaving a single backslash to be matched)." <URL: http://www.mysql.com/doc/S/t/String_comparison_functions.html > -- Roger --------------------------------------------------------------------- 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
