/** * Generate a critieria to search in the end of a field for sql. * * @param string $field For search in. * @param string $value That will search. * @return string that use LIKE to search in field. */ function end_with($field, $value) { return sql_criteria::upper($field) . ' LIKE ' . "'%{$value}'"; }
function has($field, $value) { return sql_criteria::upper($field) . ' ILIKE ' . "'%{$value}%'"; }