[RESOLVED] mySQL SELECT statement help

Hi, I have been looking here to try and figure out how my query should look, but could use some guidance.

I am trying to search a field in my table for more than one likeness. Can I create a query that says:

<?php

$query = "SELECT * FROM $table WHERE $search_field (LIKE '%$this%) || (LIKE '%$that%')";

?>

OR, should I just do two different query statements and concatenate the results?

Thanks!

I haven't used many LIKE querys, but this should work:

$query = "SELECT * FROM $table WHERE ($search_field LIKE '%$this%') || ($searchfield LIKE '%$that%')";

btw, you missed a closing quote on %$this%, which may have produced some of your trouble

Yes, thank you. It worked perfectly!

Brilliant

😃