fields of type int in MySQL use the like Query method

Method Reference from:

Http://stackoverflow.com/questions/8422455/performing-a-like-comparison-on-an-int-field

That is, you use the cast transformation to specify the fields and then compare them. The specific sample code is as follows:

SELECT  from WHERE CAST  as CHAR  like ' %15% '

But in doing so, MySQL cannot use the corresponding int field index, and the like itself is very slow.

Creating an extra field the varchar type corresponds to the int type, which is more efficient.

fields of type int in MySQL use the like Query method