How do i query mysql database using where like or like in array?

Question

How do i query mysql database using where like (array) or like (array)?

Answer 1

TRY TO USE OR

SELECT * FROM table WHERE field like '%ietm1%' OR field like '%item2%' OR field like '%item3%' 

OR

        <?php

    $sql = array('0'); // Stop errors when $words is empty

    $words =array('df','sdfds','dsfdsf');

    foreach($words as $word)
    {
        $sql[] = 'field  LIKE %'.$word.'%';
    }

    $sql = 'SELECT * FROM table WHERE '.implode(" OR ", $sql);

    echo $sql;

    ?>