Mybatis中PostgreSQL的LIKE关键字使用大全
SELECT * FROM public."user"
WHERE UPPER(username) LIKE UPPER('%' || #{username} || '%');
SELECT * FROM public."user"
WHERE CONCAT(username) LIKE CONCAT('%', #{username}, '%');
SELECT * FROM public."user"
WHERE username LIKE '%' || #{username} || '%';
正文到此结束
热门推荐
相关文章
该篇文章的评论功能已被站长关闭