Mysql's LIKE is missbehaving with Hebrew and backslashes, why?

Posted by Itay Moav on Stack Overflow See other posts from Stack Overflow or by Itay Moav
Published on 2009-10-14T17:51:45Z Indexed on 2010/03/13 15:05 UTC
Read the original article Hit count: 228

Filed under:
|
|
|

I have the following SQL query which returns the correct results:

SELECT *
FROM `tags`
WHERE tag_name = '???\\\"?-???????'

If I change it to

SELECT *
FROM `tags`
WHERE tag_name LIKE '???\\\"?-???????'

or to

SELECT *
FROM `tags`
WHERE tag_name LIKE '???\\\"?-???????%'

It doesn't work. It will work if I remove all the backslashes and " from the query.

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql