If MySQL column/field values are in an PHP array

From: Date: Thu, 19 Jul 2007 12:33:49 +0000
Subject: If MySQL column/field values are in an PHP array
Groups: php.general 
Request: Send a blank email to php-general+get-259171@lists.php.net to get a copy of this message
I created an array using the following: $in_list = "'".join("','",$cen_chiefs)."'"; //$cen_chiefs is an array $query_cen_chiefs = "SELECT * FROM central WHERE CONCAT(strName,' ',strCity,' ',strState) IN({$in_list})"; How would I go about adding an AND clause to the above query to return all rows where strName column values are in $in_list array I acutally did the above w/ "SELECT * FROM central WHERE CONCAT(strName,' ',strCity,' ',strState) IN({$in_list}) AND (strName) IN({$in_list}) ORDER BY conName"; // This return zero rows. I think I Should I be using strName as a pattern, because strName would be a partial value of $in_list array values? Something like: REGEXP '^.....$' "SELECT * FROM central WHERE CONCAT(strName,' ',strCity,' ',strState) IN({$in_list}) AND (REGEXP '^strName$') IN({$in_list}) ORDER BY conName"; //This query doesn't work by the way. This is where I'm stuck.

« previous php.general (#259171) next »