如果不考虑执行效率,只考虑开发效率,可以这样干:构造一张新表,把字段拼接起来, 然后用新造字段去匹配条件: SELECT * FROM (SELECT concat(column_1, column_2, column_3, t_tag) as ccc, ... FROM t_user left join t_tag) as A WHERE ccc like keyword_A and ccc like keyword_B and ccc like keyword_C AND ccc not like keyword_D