SQL where incoming types are different, resulting in query result variance issues

The story is like this. Please listen to the niche slowly:

The original data styles are as follows:

Normal results:

Problem presentation:

The main reasons for this problem are as follows:

The following can be found on the official website:

　

For data types from high to Low: (PS: Niche translator with translation tools, not this caught dead)

Depending on the type, the large type is converted to a small type

This is a critical value issue:

The hypothesis of combining niche:

The 11,12,13,15 string is converted to an integer 11, and all where cols=11 is established.

Mysql:http://dev.mysql.com/doc/refman/5.7/en/type-conversion.html

SQL where incoming types are different, resulting in query result variance issues