如何在mysql中查询所有表中的指定字段

mysql如何在指定数据库中查询所有表中的指定字段

下面是 查询sql，从test-db表中查询带phone、mobile的字段，以及id_card字段。

SELECT DISTINCT
	TABLE_NAME AS '表名',
	COLUMN_NAME AS '列名',
	DATA_TYPE AS '数据类型',
	COLUMN_COMMENT AS '注释' 
FROM
	information_schema.`COLUMNS` 
WHERE
	TABLE_SCHEMA = 'test-db' 
	AND COLUMN_NAME LIKE "%phone%" 
	OR COLUMN_NAME LIKE "%mobile%" 
	OR COLUMN_NAME = "id_card" 
ORDER BY
	TABLE_NAME,
	ORDINAL_POSITION;