>-----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 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? > [JS] Strings that are used in LIKE operations are parsed twice, so you need four back-slashes. That's just the way it works.
>also when i am doing: when i am doing:select cpe_id from cpe_users where >cpe_id = 'd\\\\d' >> I do get the one result >why? > >Thanks, Yariv > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/mysql?unsub=jschwa...@the- >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
