php查询mysql逗号_PHP：在mysql中搜索逗号分隔的字符串？

您需要使用OR将其分解为单独的LIKEs，例如：

...WHERE location LIKE '%{$area}' AND (name LIKE '%{$name1}%' OR name LIKE '%{$name2}' OR ...)您可以使用一些PHP逻辑简单地编写这个：

function build_like_or( $values, $field_name ) {

// Create an array from the comma-separated values

$names = explode( ',', $values );

// Trim all the elements to remove whitespaces

$names = array_map( 'trim', $names );

// Remove empty elements

$names = array_filter( $names );

$where = array();

// Loop over each, placing the "LIKE" clause into an array

foreach( (array)$names AS $name ) {

$where[] = "{$field_name} LIKE '%{$name}%'";

}

// Glue up the LIKE clauses.

$where = '(' . implode(' OR ', $where) . ')';

// Results will be something like:

// $where = "(name LIKE '%santadar%' OR name LIKE '%HSBC%')"

return $where;

}用法：

$area = 'London';

$res = 'santandar, HSBC, RBS, ';

$name_where = build_like_or( $res, 'name');

$sql = "SELECT * FROM banks WHERE location LIKE '%$area%' AND {$name_where}";

// echo $sql outputs "SELECT * FROM banks WHERE location LIKE 'London' AND (name LIKE '%santadar%' OR name LIKE '%HSBC%' OR name LIKE '%RBS%')