Laravel中区分大小写的where语句 [英] Case-sensitive where statement in laravel

问题描述

我如何使用laravel区分大小写的字符串?

How can I do a case-sensitive string match with laravel?

SELECT *从`invites`中，在`token` ='OGwie2e2985tOEGewgu23hUFs'

可以通过

Invite :: where('token'，$ token)-> first()

如果我想要区分大小写的匹配，则需要使用这样的语句(据我所知类似):

If I want a case-sensitive match I need to use a statement like this (or similar, as far as I know):

SELECT *从`invites`的WHERE BINARY`token` ='OGwie2e2985tOEGewgu23hUFs'

我最好的猜测是:

Invite :: whereRaw("BINARY`token` ='{$ token}'")-> first()

但是我的输入没有经过准备好的语句，对吧?

but then my input is not going through a prepared statement, right?

推荐答案

您需要使用DB :: raw()，也许类似

You'll need to use DB::raw(), perhaps something like

Invite::where(DB::raw('BINARY `token`'), $token)->first();

或者:

Invite::whereRaw("BINARY `token`= ?",[$token])->first()

这篇关于Laravel中区分大小写的where语句的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！