Results 1 to 1 of 1
Thread: Problem with special chars
Mar 17, 2005, 01:30 #1
- Join Date
- Mar 2005
- 0 Post(s)
- 0 Thread(s)
Problem with special chars
My php form write data using addsleshes to Mysql database (if someone write ' or " in database stays \' or \").
And now problem:
How can I use special chars (" or ') in ,,like,, query?
In command prompt I'm accessing to Mysql server and when I do select * I can see, for example, that word Rock' is supstitude with Rock\' and that is OK. But I can't define like query with quotation mark (') which result with Rock' :
select * from table where name like '%ock'%' - return quotation error
select * from tabela where naziv like '%ock\'%' - return Empty set
Help please (sorry about English)