Laravel Eloquent 忽略大小写

2021-12-26 00:00:00 orm lowercase mysql laravel eloquent

我正在尝试使用 Eloquent 运行查询$vars['language'] 是小写的，但语言列不一定是小写的.我如何使用 eloquent 进行此搜索，但查询中仍有小写

I am trying to run a query using Eloquent the $vars['language'] is in lower case but the language column is not necessarily in lower case. How can i do this search using eloquent but still have the lower case in the query

Item::where('language', $vars['language'])

我想做的是这个，即使我在任何地方都找不到如何做到这一点

What i want to do is this even though i can't find anywhere how to do this

Item::where('LOWER(language)', $vars['language'])

这样它们都是小写的，然后我可以让它们匹配.

so that they are both in lowercase and then i can get them to match.

推荐答案

使用 whereRaw 和 参数绑定 清理您的 whereRaw 语句:

Use whereRaw with parameter binding to sanitize your whereRaw statement:

$term = strtolower($vars['language']);
Item::whereRaw('lower(language) like (?)',["%{$term}%"])->get();

上一个回答在某些数据库中，您可以在您所在的位置使用运算符 ilike.例如

Prev answer In some dabases you can use operator ilike in your where. For example

Item::where('language', 'ilike', $vars['language'])->get();

所有可用的运算符是:

protected $operators = array(
    '=', '<', '>', '<=', '>=', '<>', '!=',
    'like', 'not like', 'between', 'ilike',
    '&', '|', '^', '<<', '>>',
);

ilike 不区分大小写like.

相关文章