MySQL search multiple words in loop

Question

$keywords=array("test","tset");
$matches = implode(',', $keywords);
$sql = "SELECT * FROM `reg` WHERE title like in '%$matches%' group by p_title";

$data = mysql_query($sql); 
while($info=mysql_fetch_array($data))
{
Print " {$info['title']}<br /> ";
}

I want to write a query like

   $sql = "SELECT * FROM `reg` WHERE title like in '%test%' group by p_title";
   $sql = "SELECT * FROM `reg` WHERE title like in '%tset%' group by p_title";

........

How can I search for each keyword in one query ?

http://stackoverflow.com/questions/1127088/mysql-like-in – user20232359723568423357842364 May 08 '13 at 14:11 — user20232359723568423357842364, May 08 '13 at 14:11

score 1 · Answer 1 · answered May 08 '13 at 14:10

1

"SELECT * FROM reg WHERE title like in '%test%' or  title like in '%tset%' group by p_title"

answered May 08 '13 at 14:10

웃웃웃웃웃

11,829
15
59
91

if I have 15 different words in array, should I write a long query for each case ? – Mamas Plodos May 08 '13 at 14:12
No you have to use loop for that – 웃웃웃웃웃 May 08 '13 at 14:13

ddavison · Answer 2 · 2013-05-08T14:31:17.733

0

SELECT * FROM reg WHERE title like in '%{$keywords[0]}%' or title like in '%{$keywords[1]}%'

I'd advise using a loop for this. Example:

Note: this is pretty psuedo-ey

$query = "SELECT * FROM reg WHERE title like in ";
foreach ($keyword in $keywords) {
  if (!$keyword is last)
    $query .= "'%$keyword%' or title like in ";
  else $query .= "'%$keyword%' group by p_title"
}

then evaluate $query

edited May 08 '13 at 14:31

answered May 08 '13 at 14:12

ddavison

28,221
15
85
110

at the last loop -> '%$keyword%' or title like in group by p_title.. How can I remove the or title like in at the end ? – Mamas Plodos May 08 '13 at 14:28
@MamasPlodos updated to suit that question – ddavison May 08 '13 at 14:32

score 0 · Answer 3 · edited May 23 '17 at 10:25

0

See this post: MySQL LIKE IN()?

$keywords=array("test","tset");
$matches = implode('|', $keywords);
$sql = "SELECT * FROM `reg` WHERE title REGEXP '%$matches%' group by p_title";

$data = mysql_query($sql); 
while($info=mysql_fetch_array($data))
{
    Print " {$info['title']}<br /> ";
}

edited May 23 '17 at 10:25

Community

1
1

answered May 08 '13 at 14:14

user20232359723568423357842364

4,624
1
18
28

Mudassir Hasan · Answer 4 · 2013-05-08T14:23:36.750

0

$sql = "SELECT * FROM `reg` WHERE title ";

$where='';
foreach($keywords as $val)
{
  $where .= "LIKE '%$val%' OR title ";

}
$where = substr($where , 0, -9); // to remove last OR 
$finalSql = $sql .$where;

$data = mysql_query($finalSql);

edited May 08 '13 at 14:23

answered May 08 '13 at 14:18

Mudassir Hasan

28,083
20
99
133

score 0 · Answer 5 · answered May 08 '13 at 14:33

implode PHP function allows to implement that without a loop:

$keywords=array("test","tset");
$matches = implode("%' OR title LIKE '%", $keywords);
$sql = "SELECT * FROM `reg` WHERE title LIKE '%$matches%' group by p_title";

$data = mysql_query($sql); 
while($info=mysql_fetch_array($data))
{
Print " {$info['title']}<br /> ";
}

MySQL search multiple words in loop

5 Answers5