MySQL查询操作

MySQL查询操作

1、逻辑运算符or and

mysql> select * from class;
+------+----------+--------+------+
| id   | name     | gender | age  |
+------+----------+--------+------+
|    1 | zhangsan | M      |   15 |
|    2 | lisi     | F      |   16 |
|    3 | wangwu   | M      |   13 |
|    4 | bob      | M      |   17 |
|    5 | xiaoming | M      |   18 |
+------+----------+--------+------+
5 rows in set (0.00 sec)

#查询id=1或者age=13的记录。
mysql> select * from class where id=1 or age=13;
+------+----------+--------+------+
| id   | name     | gender | age  |
+------+----------+--------+------+
|    1 | zhangsan | M      |   15 |
|    3 | wangwu   | M      |   13 |
+------+----------+--------+------+
2 rows in set (0.00 sec)

#查询gender为M且age=13的记录。
mysql> select * from class where gender='M' and age=13;
+------+--------+--------+------+
| id   | name   | gender | age  |
+------+--------+--------+------+
|    3 | wangwu | M      |   13 |
+------+--------+--------+------+
1 row in set (0.00 sec)

#查询age不在14到16之间的。
mysql> select * from class where age not between 14 and 16; 
+------+----------+--------+------+
| id   | name     | gender | age  |
+------+----------+--------+------+
|    3 | wangwu   | M      |   13 |
|    4 | bob      | M      |   17 |
|    5 | xiaoming | M      |   18 |
+------+----------+--------+------+
3 rows in set (0.02 sec)

2、模糊查询

select [字段名] from 表名 whrer [字段名] like ‘通配符’ ---->%任意多个字符 "_"可以匹配单个字符。

mysql> select name from class where name like '