>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
>-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
>data
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!
wh
