t1.`(dt|cz)?+.+` select t1.`(dt|cz)?+.+` from test001 t1 where dt='20190911' and cz='u';即查询表中出dt和cz外其他字段