How to do pdo prepared statements with multiple options for the same field?

Asked Apr 02 '19 at 18:15

Active May 27 '22 at 14:35

Viewed 35 times

I need to query the data base for multiple options for the same field in the where clause.

Example:

select * from table where (name='john' or name='phil' or name='ann')

For one selection I would write:

select * from table where name='john'

How would you do it for the multiple options? (name='john' or name='phil' or name='ann')

asked Apr 02 '19 at 18:15

Calvin

1

`WHERE name IN (?)` – danronmoon Apr 02 '19 at 18:17
I would use `IN` here. Such as: `where name in ('john', 'phil', 'ann')`. – gen_Eric Apr 02 '19 at 18:17
how would you bind them? "name in ( :namelist )" ??? – Calvin Apr 02 '19 at 18:19
@Calvin please see this answer https://stackoverflow.com/questions/7044144/binding-parameters-for-where-in-clause-with-pdo/7044270 You cannot bind a list in a single bind – imposterSyndrome Apr 05 '19 at 08:01

0 Answers0