Question

sql语句拼接字段后再模糊查询如何写啊？

select concat(`jy_name1`,`jy_email1`) as a from test where a like '%m%'where子句如何引用前面的a字段啊？

Answer 1

sql里面没有concat这个函数，不过实现拼接可以这样。select (fa+fb)as fc from @t where fa+fb like '%s%'

Answer 2

--这个用视图吧？
create view v$_viewname
as
select concat(`jy_name1`,`jy_email1`) as a from test where a like '%m%‘
--然后用视图查询你想要的条件

Answer 3

select concat(`jy_name1`,`jy_email1`) as a from test where concat(`jy_name1`,`jy_email1`) like '%m%'where