If MySQL column/field values are in an PHP array
| From: | kvigor | 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.