在使用MySQL进行数据筛选操作时，可以使用“SELECT”语句结合“WHERE”子句来实现。下面是一些常见的筛选操作：

1. 筛选特定字段：

语法：SELECT 字段1, 字段2, ... FROM 表名 WHERE 筛选条件;

示例：SELECT id, name, age FROM students WHERE age > 18;

2. 筛选满足条件的记录：

语法：SELECT * FROM 表名 WHERE 筛选条件;

示例：SELECT * FROM students WHERE gender = '男';

3. 使用比较运算符进行筛选：

- 等于：=

示例：SELECT * FROM students WHERE age = 20;

- 不等于：<>

示例：SELECT * FROM students WHERE age <> 20;

- 大于：>

示例：SELECT * FROM students WHERE age > 18;

- 大于等于：>=

示例：SELECT * FROM students WHERE age >= 18;

- 小于：<

示例：SELECT * FROM students WHERE age < 18;

- 小于等于：<=

示例：SELECT * FROM students WHERE age <= 18;

4. 使用逻辑运算符进行筛选：

- 与：AND

示例：SELECT * FROM students WHERE age > 18 AND gender = '男';

- 或：OR

示例：SELECT * FROM students WHERE age > 18 OR gender = '女';

- 非：NOT

示例：SELECT * FROM students WHERE NOT age > 18;

5. 使用通配符进行模糊筛选：

- LIKE

示例：SELECT * FROM students WHERE name LIKE '张%';

- NOT LIKE

示例：SELECT * FROM students WHERE name NOT LIKE '李%';

- IN(列表)

示例：SELECT * FROM students WHERE age IN (20, 21, 22);

- NOT IN (列表)

示例：SELECT * FROM students WHERE age NOT IN (20, 21, 22);

6. 使用ORDER BY进行排序：

语法：SELECT * FROM 表名 ORDER BY 字段 [ASC | DESC];

示例：SELECT * FROM students ORDER BY age ASC;

以上是一些常见的MySQL数据筛选操作，根据实际需要，可以组合使用不同的条件和运算符来达到所需的筛选效果。