模糊查询|模糊查询,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}%'

    推荐阅读