Laravel模糊查询区分大小写的实例分享！

Laravel的ORM特殊操作！

举个例子：我们数据库设计的编码方式如果是ci,也就是说大小写不敏感的话，我们搜索的时候，搜索test，那么结果是Test,test,teST等等都出来，但是我们加上like binary的话，那么搜索出来的就是test，不管你的mysql数据库是什么编码排序规则。

  #passthru: array:10 [▼   0 => “insert”   1 => “insertGetId”   2 => “getBindings”   3 => “toSql”   4 => “exists”   5 => “count”   6 => “min”   7 => “max”   8 => “avg”   9 => “sum”   ]   #operators: array:26 [▼   0 => “=”   1 => “<”   2 => “>”   3 => “<=”   4 => “>=”   5 => “<>”   6 => “!=”   7 => “like”   8 => “like binary”   9 => “not like”   10 => “between”   11 => “ilike”   12 => “&”   13 => “|”   14 => “^”   15 => “<<”   16 => “>>”   17 => “rlike”   18 => “regexp”   19 => “not regexp”   20 => “~”   21 => “~*”   22 => “!~”   23 => “!~*”   24 => “similar to”   25 => “not similar to”   ]  

参考文件位置：

  D:phpStudyWWWBCCAdminV1.0vendorlaravelframeworksrcIlluminateDatabaseQueryBuilder.php

   protected $bindings = [    'select' => [],    'join' => [],    'where' => [],    'having' => [],    'order' => [],    'union' => [],   ];

   protected $operators = [    '=', '<', '>', '<=', '>=', '<>', '!=',    'like', 'like binary', 'not like', 'between', 'ilike',    '&', '|', '^', '<<', '>>',    'rlike', 'regexp', 'not regexp',    '~', '~*', '!~', '!~*', 'similar to',    'not similar to',   ];

  public function index($customer_type = null) {   $search = request('search');   $perPage = request('perPage') ? request('perPage') : 10;   $customer_type = $customer_type ? $customer_type : request('customer_type');   $data = Customer::select(['id', 'email', 'user_name', 'nick_name', 'status', 'phone', 'create_time'])    ->where('customer_type', '=', $customer_type)    ->where(function ($query) use ($search) {     if ($search) {      $query->where('user_name', 'like binary', '%' . $search . '%')       ->orWhere('nick_name', 'like binary', '%' . $search . '%')       ->orWhere('phone', 'like binary', '%' . $search . '%')       ->orWhere('email', 'like binary', '%' . $search . '%');     }    })    ->orderBy('create_time', 'desc')    ->paginate($perPage);   //追加额外参数，例如搜索条件   $appendData = $data->appends(array(    'search' => $search,    'perPage' => $perPage,   ));   return view('admin/customer/customerList', compact('data'));  }

以上这篇Laravel模糊查询区分大小写的实例就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持<计算机技术网(www.ctvol.com)!!>。

—-想了解Laravel模糊查询区分大小写的实例分享！且更多的php教程关注<计算机技术网(www.ctvol.com)!!>