在MySQL中,您可以使用SELECT语句来筛选数据。以下是一些常用的筛选数据的方法:
SELECT * FROM table_name WHERE column_name = value;
SELECT * FROM table_name WHERE column1 = value1 AND column2 = value2;
SELECT * FROM table_name WHERE column1 = value1 OR column2 = value2;
SELECT * FROM table_name WHERE column_name LIKE 'pattern';
SELECT * FROM table_name WHERE column_name IN (value1, value2, value3);
SELECT * FROM table_name WHERE column_name BETWEEN value1 AND value2;
这些是常用的筛选数据的方法,在实际应用中您可以根据具体的需求来选择合适的方法来筛选数据。