mysql ×ֶβéѯµÄÎÊÌ⣬ÔÚÏßµÈ

mysql ÖеÄs±íÖÐÓÐÒ»×Ö¶ÎÃûΪfloor¡¡£¨Â¥²ãµÄÒâ˼£©¡¡Öµ¡¡Èç¡¡5/6¡¡ÒâΪµÚÎå²ã¡¡×ܲãÊýΪ6
ÏÖÏë²é¡¡µÚ5²ã¡¡µÄËùÓмǼ
ÔõôʵÏÖѽ£¬¶àл

---

select * from ±í where floor like '5/%'

---

select * from ±í where floor like '%5/%'

---

SQL code:
select * from s±í where `floor` like '5/%'

---

°´Â¥Ö÷µÄÒâ˼,Èç¹û¹²6ÎÝ,²éµÚÎå²ãÖ±½Ó where fllor='5/6',·ñÔòwhere fllor like '%5/%'²éËùÓÐÂ¥µÄµÚÎå²ã!

---

select * from s±í where `floor` like '5/%'

·Ç
select * from s±í where `floor` like '%5/%'
ºóÕßÓпÉÄÜËѵ½15Â¥£¬25Â¥

---

ѧϰÁË

---

select * from `s±í` wherefloor regexp "^5/[0-9]$";

---

ÒýÓÃ

select * from `s±í` where floor regexp "^5/[0-9]$";

SQL code:

select * from `s±í` where floor regexp "^5/[0-9]+$";

---

¶àл
select * from ±í where floor like '5/%'