mysql like µÄÓ÷¨

select * from table where name like "%123%";

ÕâÑùÊDzéѯ³ö Ãû×ÖÖаüº¬123 µÄÊý¾Ý£¬ÎÒÈç¹ûÒª²éѯÃû×ÖÖв»°üº¬123µÄÊý¾Ý Ôõô²éÄØ£¿

select * from table where name no like "%123%"; ºÃÏñ²»ÐС£

---

select * from table where name not like "%123%"; ºÃÏñ²»ÐÐ
{{