spatie/laravel-searchable

` or "

SocolaDaiCa opened this issue · 0 comments

$expectedQuery = 'select * from "test_models" where (LOWER("name") LIKE ?) or ("gender" = ? and "status" = ?)';

In my computer when I use

select * from "test_models" where (LOWER("name") LIKE ?) or ("gender" = ? and "status" = ?)

It will error
I only use

select * from `test_models` where (LOWER(`name`) LIKE ?) or (`gender` = ? and `status` = ?)

I dont know why you use " instead `