1
Hi All,
This can't be hard but it is driving me nuts.
The following query does not produce any results when I can clearly see the correct row in the database :
SELECT * FROM `tablename` WHERE NAME = 'A name with ' a single quote';
I have tried every possible adaptation but can't select a row based on a string with a single quote in it.
Phpmyadmin suggests the following :
SELECT *
FROM `tablename`
WHERE `NAME` LIKE CONVERT( _utf8 'A name with \'' a single quote'
USING latin1 )
COLLATE latin1_swedish_ci
LIMIT 0 , 30
But still does not produce my row.
The string stored in the database is simply the following :
name with \' a single quoteCan someone please tell me how to select it !?
Kind regards,
Highlander
edit: seems to have been submitted twice, could an admin press delete ?
