/**查询mysql表的字段信息**/ select COLUMN_NAME,column_comment from INFORMATION_SCHEMA.Columns where table_name='表名' and table_schema='数据库名'
/**like反向查询**/
id field
1 hello
2 hi
SELECT * FROM db.table WHERE $str LIKE CONCAT('%',field,'%');
select * from db.table where "见面打招呼说hello, 你好~" like concat("%", field,"%");
result:
id field
1 hello