query with in_array?

[vaaaska]

It gets more difficult all the time to try to find things in here with the search tools...I'm sure this has been approached in here before, but I can't find anything...

Is it possible to have an in_array type function inside of a query...

like (in_array('field_values', $array))...which would need to be something more like this (i think)...

...WHERE field_values='$array'

hmmm...i can think of a bunch of reasons why that's not good...

is there a technique for doing this?

thanks...v

[Shrike]

Wrong forum, but in_array returns TRUE or FALSE rather than values.

[vaaaska]

ack!

sorry...total mistake on the forum...woops!

😉

[mtimdog]

MYSQL has an IN LIST feature....something like

where $id IN {9,5,4}

[vaaaska]

thanks, somebody pointed this out to me...

they've been updating mysql.com...i tried digging through their online manual and i couldn't find what i needed...

how do you search for "IN"? or even "in_array" at this forum? i seem to be able to find less and less...v

[mtimdog]

on mysql.com here , search for "expr IN (value,...) "