Why does this string comparision mysql query return nothing?

Question

I execute the following:

SELECT url FROM mytable WHERE 1

result: url: 'http://www.ciao.es/Epson_Stylus_S22__2007613'

Everything ok by now...but when I do:

SELECT * FROM mytable WHERE url = 'http://www.ciao.es/Epson_Stylus_S22__2007613'

I get nothing!!!

I tried using LIKE, changing the quotes, etc... what am I doing wrong?

Answer 1

You are having ' ' in your table field url .So if you are querying you will get output like this: 'http://www.ciao.es/Epson_Stylus_S22__2007613' (with in single quote) SO Write in this way:

SELECT * FROM mytable WHERE url = "'http://www.ciao.es/Epson_Stylus_S22__2007613'"

Or remove single quote from table.