Searching ALL Columns for keyword?

[tyhoerr]

Hello,

I'm trying to build a keyword search for a database of plants for a client... I'm not well versed in sql and the deadline is tomorrow to get this working... I've had no luck in the past 24 hours finding a solution on the internet.

Basically what I want it to do is take a keyword (or series of keywords) and search the ENTIRE database for anything like those words. I was able to get it working for searching ONE column using this code:

$find=ltrim($find);
$find=rtrim($find);

$kt=split(" ",$find);

while(list($key,$val)=each($kt)){
if($val<>" " and strlen($val) > 0){$q .= " upper(Description) like '%$val%' or ";}

}
$q=substr($q,0,(strlen($q)-3));

$query="select * from Master_table where $q ";

But this will only search the "Description" column, and not the other 15 columns of information. How can I code it to search through ALL of the columns and not just one of them?

Thanks in advance for any help!!

[tyhoerr]

Figured it out! Thanks!

[Roger_Ramjet]

For future reference you should learn about Full Text Search http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html as this is the correct tool for this job. You might even want to do this for your current client as an update.

[_sh]

Could you also post your solution for future reference of others.