Question

数据库里，关于模糊查询的问题

select posName from posEqual where posEqualInfor like '%STR%'

在上边这个sql语句里，如何将STR定义为一个变量？ STR是一个字符串常量，但值是不确定的...

比如说 select posName from posEqual where posEqualInfor like '%上海%'

select posName from posEqual where posEqualInfor like '%杭州%'

Answer 1

declare @str varchar(255)

set @str = '上海'

select posName from posEqual where posEqualInfor like '%'+@str+'%'

Answer 2

select posName from posEqual where posEqualInfor like '%'"+STR+"'%'

Answer 3

String str=*****;

"select posName from posEqual where posEqualInfor like '%" + STR+ "%'"