Where clause is case insensitive?

Question

Laravel

It is necessary to fulfill the request But without regard to the case of the text.
where('text', $text)->get();

Answer 1

some tough decisions.
https://dev.mysql.com/doc/refman/5.7/en/string-fun...
bring everything to one case faster /less resource-intensive than like.
In general, then you need to use ci encoding so that records and work do not take into account the case at all.

Answer 2

%like%