Mysql multi-field keyword fuzzy query method

Mysql tutorial multi-field keyword fuzzy query method

To query several fields in a mysql SQL statement, we need to use the concat () function of the string join function,

String concat (string, string, string *)

The following function call returns "abcdefg ":

Copy concat ("abc", "d", "ef", "g ")
The following function call returns "abc3efg ":

Copy concat ("abc", 3, "ef", "g ")

At the same time, we will also use like %. below is the SQL statement we want.

 

Select * from 'magazine' where concat ('title', 'tag', 'description') like '% keyword %'

The principle is to use concat to join several fields and then use like to query ko.