Laravel雄辩地忽略套管 [英] Laravel Eloquent Ignore Casing

问题描述

我正在尝试使用Eloquent运行查询 $ vars ['language']用小写字母表示，但language列不一定用小写字母表示.我该如何用雄辩的方式进行搜索，但查询中仍然使用小写字母

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雄辩地忽略套管的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！