[RESOLVED] how to search a column in MySQL for a words in an array

[lli2k5]

I'm trying to build a query in mysql that searches for whether a column of strings contains any word from an array of words.

let's say the array is {'cats', 'dogs', 'bears'}

How can you perform a query in MySQL to return all rows that contain any of these words?

"SELECT * FROM table WHERE description=????????

[edit: the column contains sentences]

[bradgrafelman]

$keywords = array('cats', 'dogs', 'bears');
$column = 'description';

foreach($keywords as $word) {

if(!isset($where_stmt))
    $where_stmt = "$column LIKE '%$word%'";
else
    $where_stmt .= " OR $column LIKE '%$word%'";

}

$query = "SELECT * FROM table WHERE $where_stmt";