Mysql separates the search string with a space and inserts a query

Question

Search query:

"product1 prod2 prod4"

I need to do mysql

SELECT * 
  FROM tableprod 
  WHERE (prod LIKE '%product1%' 
         AND prod LIKE '%prod2%' 
         AND prod LIKE '%prod4%')

using mysql_real_escape_string for input request ...

Answer 1

Simple string manipulation:

$terms = explode(' ', $search);

$bits = array();
foreach ($terms as $term) {
    $bits[] = "prod LIKE '%".mysql_real_escape_string($term)."%'";
}

$query = "SELECT * FROM tableprod WHERE (".implode(' AND ', $bits).")";

Answer 2

If you cope with the restrictions, it would be better for you to use the FULLTEXT index , which saves you from having to split the string, plus you get a bonus to be able to use basic logical operators for searching (and / or / not)

Answer 3

( ):

$str = "product1 prod2 prod4";
$sql = "select * from tableprod where (prod like '%" . str_replace( ' ', '%\' AND prod LIKE \'%', $str ) . '%\')';

, , preg_replace