[Resolved] Search doubt ¿?

[plasmahba]

Hello!

I have this search and it is not working well. it works if I only leave one option.

Any help?

$result = mysql_query("SELECT
*
FROM db
WHERE
Owner
AND ManagerFirstName
AND ManagerLastName
AND ContactLastName
AND ContactFirstName

LIKE '%$Search%' ORDER BY ID");

If I only leave ContactFirstName for example, it works, otherwise the search doesn´t find any result

Maybe I`m missing something elementary here

Thanx

[plasmahba]

Yeah I am missing something elementary and it is that the search is looking for the same result in oall the options that`s why.

Now does someone knows if there is an instruction like OR instead of AND?

Thanks