I have a php code with a string that I'm trying to find in an MySql database.
But...I'm getting empty result set.
The database has a varchar column named news_url with this in it "/is/frettir/titill".
What I'm trying to do is search for this row with that string in the db.
I have a string variable in php
$curl = "/is/frettir/titill";
and this query:
SELECT * FROM news WHERE news_url LIKE '$curl'
(SELECT * FROM news WHERE news_url LIKE '/is/frettir/titill/')
I'm trying to find exactly that string. Not something like "/is/frettir/titill/morestuff" or "/is/frettir/" so what am I doing wrong? :/