MySQL是目前最為廣泛使用的關系型數(shù)據(jù)庫管理系統(tǒng)。在日常開發(fā)中，我們經(jīng)常需要查詢數(shù)據(jù)庫中的數(shù)據(jù)。本文將介紹一些MySQL查詢中的新用法，讓我們的查詢更加高效、靈活。

1. 查詢多個表的數(shù)據(jù)
SELECT table1.column1, table2.column2 
FROM table1
INNER JOIN table2
ON table1.column = table2.column;
2. 模糊查詢
SELECT * FROM table_name
WHERE column_name LIKE '%search_keyword%';
3. 分組查詢
SELECT COUNT(*), column_name 
FROM table_name
GROUP BY column_name
HAVING COUNT(*) >1;
4. 排序查詢
SELECT * FROM table_name
ORDER BY column_name ASC|DESC;
5. 查詢范圍內(nèi)的數(shù)據(jù)
SELECT * FROM table_name
WHERE column_name BETWEEN value1 AND value2;
6. 利用子查詢進行查詢
SELECT *
FROM table_name
WHERE column_name IN
(SELECT column_name FROM another_table);
7. 統(tǒng)計數(shù)據(jù)
SELECT COUNT(column_name), AVG(column_name), SUM(column_name)
FROM table_name;
8. 時間函數(shù)和日期函數(shù)
SELECT DATE_FORMAT(column_name, '%format')
FROM table_name;
9. 多表聯(lián)合查詢
SELECT *
FROM table1
LEFT JOIN（或 RIGHT JOIN）table2
ON table1.column_name = table2.column_name
WHERE table1.column_name=value;
10. 隨機查詢
SELECT column_name
FROM table_name
ORDER BY RAND()
LIMIT 5;

以上是MySQL查詢中的一些新用法，我們可以根據(jù)實際需求進行選擇，讓查詢變得更加高效、靈活。