Search question

[micmac]

Hi all,
What would be the best way to comine these two search queries.
They both work well on there own but for different reasons.
Any ideas?

$sql="SELECT * FROM $table WHERE MATCH ($searchtype,$searchtype1,$searchtype2) AGAINST ('%$searchstring%') AND active='yes'";

$sql="SELECT * FROM $table WHERE (($searchtype LIKE '%$searchstring%') OR ($searchtype1 LIKE '%$searchstring%') OR ($searchtype2 LIKE '%$searchstring%')) AND active='yes' ORDER BY CatName ASC"; 

[e-novative]

Let the database do it and combine both where clauses, either by OR or by AND, depending on what you prefer ...

Cheers,

Steve