Project

General

Profile

Download (542 Bytes)

Feature #24110 » 16451-find-in-set.patch

Administrator Admin, 2010-11-17 17:44

View differences:

class.t3lib_db.php (working copy)
*/
function listQuery($field, $value, $table) {
$command = $this->quoteStr($value, $table);
$where = '('.$field.' LIKE \'%,'.$command.',%\' OR '.$field.' LIKE \''.$command.',%\' OR '.$field.' LIKE \'%,'.$command.'\' OR '.$field.'=\''.$command.'\')';
$where = 'FIND_IN_SET(' . $command . ', ' . $field . ')';
return $where;
}
(2-2/2)