Using escape string error in MySQL select command, any one can help me?

myunicom · 02-16-2004, 11:25 AM

Using escape string error in MySQL select command, any one can help me?

hello:

when I using the following select command, the syntax error appears.

select * from tablename where name like \'Mecki\' ;

what is going on? who can tell me why? thanks for your helping in advance.

myunicom

trickykid · 02-16-2004, 12:06 PM

Well with your select command there, I really don't see a reason why you need the \ 's in there?

Can't you do the same select with something like this:

select * from tablename where name like 'Mecki' ;

myunicom · 02-16-2004, 09:20 PM

thanks.

I am writing a PHP + MySQL web script. I use a <input type=text ....> to collect the select command in the web client, when the form posted, the punctuation ' will escaped as \' automatically. I don't know how to unescape the \' in PHP. if I use the escaped punctuation \' , the select syntax error will appear.

myunicom