MYSQL OR Statement Help
Posted on 2008-06-11
$query = "select * from vendor where (businessname OR primarycontact OR estimatingcontact OR ownerofficercontact) like \"%$trimmed%\" order by businessname"; // EDIT HERE and specify your table and field names for the SQL query
I am new to using OR statements.
Is my syntax above correct, its returning no results.
If I do just businessname, I have results.