Doing a keyword search with MySQL database query

[redsox9]

Okay, here's what I want to do: I have a MySQL database with a text field that I've labeled keywords. What I want to be able to do is a search within that field for a particular value like home run or David Ortiz. So, I did a little research to see how I might do this and the closest that I came to finding an answer looks like this:


$kw = $_GET['keyword'];
$query = "SELECT * FROM table1 t1 WHERE t1.keywords LIKE '$kw'";

As you might have guessed, it doesn't return beans. I also tried:


$query = "SELECT * FROM table1 t1 WHERE '$kw' IN(t1.keywords)";

This also did not return any results. Any thoughts? :confused:

[areidmtm]

Try


$query = "SELECT * FROM table1 t1 WHERE t1.keywords LIKE '%$kw%'";

[redsox9]

That worked like a charm!

*bows in direction of areidmtm*