How to write the fuzzy search syntax of Eloquent ORM in Laravel5.2?

Question

How to write the fuzzy search syntax of Eloquent ORM in Laravel5.2?

Answer 1

It seems that you can use the where statement.

$users = DB::table('users')->where('name', 'like', '%hello%')->get();

If you need a writing method unique to a certain database, or are not used to Eloquent's method, you can also use native SQL statements (not recommended, especially since it is easy to cause SQL injection vulnerabilities due to spelling strings) - use DB: :raw method.

$users = DB::table('users')
                     ->select(DB::raw('count(*) as user_count, status'))
                     ->where('status', '<>', 1)
                     ->groupBy('status')
                     ->get();

I just moved it from the documentation. . .

Answer 2

I recommend you an elegant writing method, which is similar to TP. Please look here
Then you can write $map = ['aa' => ['LIKE' => '%XXX%' ];