Menu
hi i only want to return rows from my db that contains a word within the string of a specific column. I guess I’ll try and explain it with pseudo code
[code=php]$search = mysql_query(“SELECT column1 FROM table1 WHERE column1 contains the word ‘bottle’ within the contents of that column”);
That’s basically it in a nutshell. I’ve been trying to use substring and substr but don’t really know if that is the right thing to use. Basically im trying to build a site search.
thanks
chris