模糊查询|模糊查询,concat和concat_ws的使用
SELECT * FROM
Project_Manage
WHERE CONCAT
(Project_Serial, Project_Name, Project_Type,
Project_Remark, Project_Manage_PersonnelNo,
Project_IsInvalidated, Project_Describe,
Project_Curr_Progress, Project_CreateUser_Id,
Project_Predict_End_DateTime, Project_Practical_End_DateTime,
Project_Create_Time, Project_Custom_SerialIP,
Project_File_Name, Project_File_Directory,
Project_CustomPort)
LIKE '%#{projectManageList}%'
推荐阅读
- 关于QueryWrapper|关于QueryWrapper,实现MybatisPlus多表关联查询方式
- mybatisplus如何在xml的连表查询中使用queryWrapper
- mybatisplus|mybatisplus where QueryWrapper加括号嵌套查询方式
- MybatisPlus使用queryWrapper如何实现复杂查询
- 数据库|SQL行转列方式优化查询性能实践
- neo4j|neo4j cql语句 快速查询手册
- 模糊的记忆
- Trie树(动态规划)
- MybatisPlus多表连接查询
- 知识扩展-SQL查询基础