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
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