SQL自学，mysql从入门到精通 --- 第 6 天，sql中的子句使用
sql中的子句
where 返回数据进行限制
root@mysqldb 10:52: [d1]> SELECT * FROM cars_price WHERE name = 'ADI';
+------+------+--------+-------+------+
| name | num | colour | price | type |
+------+------+--------+-------+------+
| ADI | 22 | red | 13 | sdfx |
+------+------+--------+-------+------+
1 row in set (0.00 sec)
like 进行模糊匹配查询
root@mysqldb 10:54: [d1]> SELECT * FROM cars_price WHERE name like "%CH%";
+---------+------+--------+-------+------+
| name | num | colour | price | type |
+---------+------+--------+-------+------+
| CHANGAN | 23 | white | 15 | zdfs |
| BCHI | 23 | white | 15