Searching for a word/term in the entire database

[j_miguel_y]

I want to find a word or a specific term in my table. How would I go to do this?

I get an error using the WHERE MATCH() AGAINST format because I use all the attributes of my tables.

This is an error:
$sql = "select * from plant_info WHERE MATCH (lighting,family,growth_rate,difficulty,genus,region,aqua_placement,plant_info) AGAINST ('".$search."')";

Are there any other ways for searching for a term in a table in a database?

[paulnaj]

Hi j,

Without looking up the details of using MATCH, surely you need to quote the listed search items ...

$sql = "select * from plant_info WHERE MATCH ('lighting', 'family', 'growth_rate', 'difficulty', 'genus', 'region', 'aqua_placement', 'plant_info') AGAINST ('".$search."')";

That might clear up the error.

Paul.