PHP mysql使用关键字搜索多个表

SELECT * FROM table1
UNION
SELECT * FROM table2

SELECT * FROM table1
UNION ALL
SELECT * FROM table2

SELECT * FROM table_name
WHERE column_name = 'value'

SELECT * FROM table_name
ORDER BY column_name ASC

SELECT * FROM table_name
LIMIT 10

SELECT * FROM table1
JOIN table2 ON table1.column_name = table2.column_name

SELECT * FROM table_name
WHERE column_name LIKE '%word%'

SELECT column_name, COUNT(*) FROM table_name
GROUP BY column_name

SELECT column_name, COUNT(*) FROM table_name
GROUP BY column_name
HAVING COUNT(*) > 10