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