Question

How to create SQL SELECT query to find all the words from array in database rows with PHP

Answer 1

$arr = array("php", "c", "c++");

$query_like = "";
foreach ($arr as $word) {
    if (empty($word)) continue;
    if ($query_like === "") {
        $query_like = "column_name LIKE '% " . $word . " %'";
    } else
        $query_like = $query_like . " AND column_name LIKE '% " . $word . " %'";
}
    
$sql =  "SELECT * FROM table_name WHERE " . $query_like;

echo $sql;




/*
run:

SELECT * FROM table_name WHERE column_name LIKE '% php %' AND column_name LIKE '% c %' AND column_name LIKE '% c++ %'

*/

 

70+ SQL courses for beginners and professionals