模糊查询,concat和concat_ws的使用

最新推荐文章于 2024-02-19 17:34:32 发布

bao_leopard

最新推荐文章于 2024-02-19 17:34:32 发布

阅读量872

点赞数 1

文章标签： select mybatis mysql

本文链接：https://blog.csdn.net/m0_37357607/article/details/71194250

版权

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}%'