问题描述
我正在尝试使用 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.
这篇关于Laravel Eloquent 忽略大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！