12.5.1 String Comparison Functions - MySQL

2002年10月10日 - Per the SQL standard, LIKE performs matching on a per-character basis, thus it can produce results different from the = comparison operator:

dev.mysql.com