将某个MSSql的like语句调整到MySql上,
Select UserName,Email from UserInfo where UserName like '%'+@Keywords+'%' or Email like '%'+@Keywords+'%'
查询语句一直报错,尝试更改为:
Select UserName,Email from UserInfo where UserName like '%@Keywords%' or Email like '%@Keywords%'
结果发现不报错了,但是参数KeyWords没有被替换成值,查了一下资料,居然发现MySql的和Oracle/MSSql的一些不同:
“mssql是用+号拼接,oracle是用||拼接,mysql就是concat(var1,var2,…..)拼接”
于是改为:
Select UserName,Email from UserInfo where UserName like concat('%',@Keywords,'%') or Email like concat('%',@Keywords,'%')