How to check in_array in query

[t_machine]

hi, I am wondering if anyone could help with this problem I am having.
I need to check if values in a table match that in an array.

example
$myarray = array();

$myarray['color']="red";
$myarray['drink']="pepsi";

$query =..... SELECT * FROM tablename Where in_array(column_name, $myarray)....

Can something like that work or would i need to display the results first then check if in array?

Thanks :)

[wildteen88]

You can not use PHP and MySQL together in a query.

You'll need to select everything from your database first and then use mysl_fetch_row and then use the in_array function.

[fenway]

Never heard of this function, but I'd imagine that if you're examing rows for multiple name/value pairs, you'd have to check each one after the query.

[t_machine]

Thank you for your replies :)
It would be very good if someday mysql would include a function like that.

[shoz]

Perhaps a query can be constructed using the array to give the results you're looking for. You'd have to explain in greater detail how the array should be looked at in relation to the information in the database.

For instance, if the keys aren't relevant to the search then you can use something similar to
[code]
<?php
$query = 'SELECT * FROM table WHERE column IN ("'.implode('","', $array).'")';
?>
[/code]

[fenway]

Yeah, I've even "cheated" before by using IN with CONCAT(), but it prevent the use of an index.  The only other way is it use a self join.