为什么我这样查询查询不到的？[email protected]?[email protected]?？？
- SQL code
select * from [User] a,Friends b,TypeFriends c where [email protected] and a.UserId=b.UserId and a.Realname like [email protected]%' and c.TypeFdsId=b.TypeFdsId
------解决方案--------------------
like [email protected]+'%'
[email protected]%'，参数带进去时，会变成：'%'参数常量'%'。所以肯定会有错。