static function search_clause($search, $fields, $mode = 'OR')
{
if (empty($search)) {
return false;
}
$arr = array();
foreach ($fields as $f) {
array_push($arr, $f . ' LIKE \'%' . $search . '%\'');
//array_push($arr, $f . ' REGEXP "[[:<:]]' . db::escape($search) . '[[:>:]]"');
}
return '(' . implode(' ' . trim($mode) . ' ', $arr) . ')';
}