See if item in table has attribute in array

[franzwarning]

Hi there,

 

Say I have some table, foo, and I want to select all rows in foo where 'name' is a member of an array of names that I have. How would I go about doing that?

 

Cheers,

George

[requinix]

Depends on the size of the array and where it's coming from. But in general you can

WHERE field IN ("value 1", "value 2", "value 3")

or

WHERE (field = "value1" OR field = "value 2" OR field = "value 3")

[fenway]

I'd definitely steer you away from multiple ORs -- just too error-prone -- and it's easy to add one more for NULLs.

[Riparian]

One way would be to select * and in the while loop use if(in_array($row[thesurname],$the_array_of_names)){do something;}

[requinix]

One way would be to select * and in the while loop use if(in_array($row[thesurname],$the_array_of_names)){do something;}

No. Very no.

[premiso]

One way would be to select * and in the while loop use if(in_array($row[thesurname],$the_array_of_names)){do something;}

 

I use this method all the time. It is very efficient and does not take long at all, +1 imo.

 

No. Very no.

 

Stop being a negative nancy.

[Jessica]

Partly it depends on where the list of names is coming from. If it's another table, use a JOIN. Otherwise, use IN.

[premiso]

Depends on the size of the array and where it's coming from. But in general you can

WHERE field IN ("value 1", "value 2", "value 3")

or

WHERE (field = "value1" OR field = "value 2" OR field = "value 3")

 

mm Double quotes work for string values in MySQL? 

[Jessica]

Yes, they do.

[premiso]

Yes, they do.

 

apparently so....apparently so.

[fenway]

One way would be to select * and in the while loop use if(in_array($row[thesurname],$the_array_of_names)){do something;}

That can't possibly be efficient for at least 23 different reasons.