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