thinkPHP or PHP project implements fuzzy query

The content of this article is about how to implement fuzzy query in thinkPHP or PHP projects. Friends in need can refer to it

How to implement fuzzy query in thinkPHP or PHP projects?

I searched online today and can use like in mysql to achieve it

How to use it?

Look at the code:

Incorrect usage:

where('title','like',$search.'%') -> select();

Correct usage:

where('title','like','%'.$search.'%') -> select();

Be sure to pay attention Use two % to wrap the keyword variable to be queried. Otherwise it will be invalid! ! ! ! ! ! ! !

Don’t step on the pits you have stepped on again! ! ! !

The above is the detailed content of thinkPHP or PHP project implements fuzzy query. For more information, please follow other related articles on the PHP Chinese website!