MySQL中的WHERE条件语句用于从表中选择特定的行，基于给定的条件来过滤数据。下面是MySQL中一些常见的WHERE条件语句：
等于 (=)：SELECT * FROM table_name WHERE column_name = ‘value’;
不等于 (<>)：SELECT * FROM table_name WHERE column_name <> ‘value’;
大于 (>)：SELECT * FROM table_name WHERE column_name > ‘value’;
小于 (<)：SELECT * FROM table_name WHERE column_name < ‘value’;
大于等于 (>=)：SELECT * FROM table_name WHERE column_name >= ‘value’;
小于等于 (<=)：SELECT * FROM table_name WHERE column_name <= ‘value’;
BETWEEN：SELECT * FROM table_name WHERE column_name BETWEEN ‘value1’ AND ‘value2’;
IN：SELECT * FROM table_name WHERE column_name IN (‘value1’, ‘value2’, …);
NOT IN：SELECT * FROM table_name WHERE column_name NOT IN (‘value1’, ‘value2’, …);
LIKE：SELECT * FROM table_name WHERE column_name LIKE ‘value%’;
NOT LIKE：SELECT * FROM table_name WHERE column_name NOT LIKE ‘value%’;
IS NULL：SELECT * FROM table_name WHERE column_name IS NULL;
IS NOT NULL：SELECT * FROM table_name WHERE column_name IS NOT NULL;
注意：这里的table_name是要查询的表的名称，而column_name则是要筛选的列（字段）名称。同时，可以使用AND、OR、NOT等关键字对多个条件进行组合。
