Re: like isn't behave as expected

2009-02-04 Thread Olaf Stein
>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

RE: like isn't behave as expected

2009-02-04 Thread Jerry Schwartz
>-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