Bug #22959 » t3lib_db_listQuery_performance.patch
| class.t3lib_db.php (Arbeitskopie) | ||
|---|---|---|
|
*/
|
||
|
function listQuery($field, $value, $table) {
|
||
|
$pattern = $this->quoteStr($value, $table);
|
||
|
$patternForLike = $this->escapeStrForLike($pattern, $table);
|
||
|
$where = '(' . $field . ' LIKE \'%,' . $patternForLike . ',%\' OR ' .
|
||
|
$field . ' LIKE \'' . $patternForLike . ',%\' OR ' .
|
||
|
$field . ' LIKE \'%,' . $patternForLike . '\' OR ' .
|
||
|
$field . '=\'' . $pattern . '\')';
|
||
|
$where = 'find_in_set(\'' . $pattern . '\',' . $field . ')';
|
||
|
return $where;
|
||
|
}
|
||