运算符 语法 描述 IS NULL a IS NULL 返回true,false IS NOT NULL a IS NOT NULL 返回true,false BETWEEN …AND… a BETWEEN b AND c 返回true,false LIKE a LIKE b 如果a匹配到b,则为真 IN a IN (b,c,d,e…) a在b c d e其中的某个中,则为真 查询昵称里带“五”字的 SELECT * FROM players WHERE `name` LIKE '%五%'