MySQL 5.5 模式匹配LIKEmysql> select * from t_test; +--------+-------------+---------+ | deptno | dname| loc | +--------+-------------+---------+ | 10 | Research| Beijing | | 20