like isn't behave as expected

Hi i have one row in the cpe_id column of the cpe_users table in my database with the value: d\d. when i am doing:select cpe_id from cpe_users where cpe_id = 'd\\d' I got the one result. when i am doing:select cpe_id from cpe_users where cpe_id like 'd\\d' I don't get any result! why?

RE: like isn't behave as expected

-Original Message- From: Yariv Omer [mailto:yar...@jungo.com] Sent: Wednesday, February 04, 2009 10:50 AM To: mysql@lists.mysql.com Subject: like isn't behave as expected Hi i have one row in the cpe_id column of the cpe_users table in my database with the value: d\d. when i am

Re: like isn't behave as expected

From http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#oper ator_like: Note Because MySQL uses C escape syntax in strings (for example, ³\n² to represent a newline character), you must double any ³\² that you use in LIKE strings. For example, to search for ³\n², specify it