Selecting multiple rows using WHERE function

Question

I am trying to search for multiple rows within a database using the PDO handler, using the WHERE function to search for multiple row/variables. I can successful search for individual items using just one name variable, however I was hoping to search for multiple. This is what I've tried but its not working:

$result=$dbh->prepare("SELECT * FROM hire WHERE name='item1', 'item2", 'item3');

Thank you very much for your help :)

You are in need of a WHERE...IN clause

segFault
– segFault

2020-01-12 02:52:42 +00:00
Commented Jan 12, 2020 at 2:52 — segFault
– segFault, Commented Jan 12, 2020 at 2:52

andrzejwp · Accepted Answer · 2020-01-12 00:21:09Z

3

If you want to choose from a set of values you can use the IN selector, like this:

$result=$dbh->prepare("SELECT * FROM hire WHERE name IN('item1', 'item2', 'item3')");

answered Jan 12, 2020 at 0:21

andrzejwp

1,0026 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Selecting multiple rows using WHERE function

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