How to match array of string in select query?

Question

I am work in php and this is my array

Array ( [0] => Sharp [1] => New [2] => Stress [3] => Bending forward [4] => Headache )

And I Want to retrieve the record which match the array value in tag column

select * 
from table_name 
where tag In(Sharp, New,Stress,Bending forward,Headache);

But above query give the error in php side as like

Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\xampp\htdocs\Demo\abc.php on line 14

And mysql side is

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'forward,Headache) LIMIT 0, 25' at line 1

Thank you in advance

Missing quotes for string

devpro
– devpro

2016-10-01 13:35:57 +00:00
Commented Oct 1, 2016 at 13:35 — devpro
– devpro, Commented Oct 1, 2016 at 13:35
but i want match all value which store in array

VishalPethani
– VishalPethani

2016-10-01 13:41:01 +00:00
Commented Oct 1, 2016 at 13:41 — VishalPethani
– VishalPethani, Commented Oct 1, 2016 at 13:41
Check the given below answers u will get the idea

devpro
– devpro

2016-10-01 13:47:14 +00:00
Commented Oct 1, 2016 at 13:47 — devpro
– devpro, Commented Oct 1, 2016 at 13:47

devpro · Accepted Answer · 2016-10-01 13:45:05Z

1

You are missing quotes for your string value.

This:

SELECT * FROM table_name WHERE tag IN (Sharp,New,Stress,Bending forward,Headache)

Should be:

SELECT * FROM table_name WHERE tag IN ('Sharp','New', 'Stress','Bending forward','Headache')

If you have an array than you can use implode()

$string = implode('","',$yourArray);

$query = 'SELECT * FROM table_name WHERE tag IN ("'.$string.'")';

One more point, as per your code error you are using mysql_* extension which is deprecated and closed in PHP 7. You can use mysqli_* or PDO.

edited Oct 1, 2016 at 13:45

answered Oct 1, 2016 at 13:38

devpro

16.1k3 gold badges29 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to match array of string in select query?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related