I have a problem. In my database there are a field, productType having data like Men's Jackets, Ladies' Gloves. When I try to run select query for productType, mysql returns with an error or empty result.
I have used mysql_real_escape_string() functions, but it works with the server version higher than 5.1.#*$!. The mysql version which I have on the serve is 5.0.9#*$!.
For version 5.1.#*$! following query is working perfect:
select * from products where productType = 'Men''s Jackets'
How can I write accurate query for mysql version 5.0.9#*$!.