mysql query question

[networkthis]

I am fairly new to mysql, I have a question on the following:

I am trying to match keywords entered into my search all box with any of the fields in my table as long as my status field is set to active: This works great as long as I use only 1 LIKE field, however when I enter multiple LIKE fields into my query I get a different number of search results if I reverse the words.... 

 

<?php

if ($search_all) {
    foreach ($search_all_array as $trimm){
$query = "SELECT * FROM db WHERE long_description LIKE '%$trimm%' OR short_description LIKE '%$trimm%' OR city LIKE '%$trimm%' AND status LIKE '%active%'";}

?>

 

Any ideas?? Thanks

[revraz]

Probably because it will stop on the first match.

[Mchl]

SELECT * FROM db WHERE (long_description LIKE '%$trimm%' OR short_description LIKE '%$trimm%' OR city LIKE '%$trimm%') AND status = 'active;