mysql - 帮助完成此搜索查询

Question

它在 phpmyadmin 第 1 行的 'SELECT c.candidate_id AS candidate_id,c.date_time_stamp AS candidate_date_time,c' 附近显示语法错误

SELECT * FROM states ORDER BY name ASC 

SELECT c.candidate_id AS candidate_id,
       c.date_time_stamp AS candidate_date_time,
       c.first_name AS first_name, c.last_name AS last_name,
       c.availability_date AS availability_date,
       c.experience_years AS experience_years,
       c.phone AS phone,c.phone_alternate AS phone_alternate,
       c.email AS email,c.bridge AS bridge,c.hot AS hot,
       c.submitted AS submitted,c.placed AS placed,
       sp.abbreviation AS specialty_abbreviation,
       jt.name AS candidate_job_type,s.first_name AS staff_first_name 
FROM candidates c 
     LEFT JOIN specialties sp ON sp.specialty_id=c.specialty_id 
     LEFT JOIN candidate_job_types jt ON jt.candidate_job_type_id=c.candidate_job_type_id 
     LEFT JOIN staff s ON s.staff_id=c.staff_id 
WHERE c.active=1 AND 
      ( CONCAT_WS(' ', c.first_name, c.last_name) LIKE '%gmail%' OR c.phone = 'gmail'       OR 
      c.phone_alternate = 'gmail' OR c.email = 'gmail') GROUP BY c.candidate_id 
 ORDER BY c.date_time_stamp DESC LIMIT 0,100 

Answer 1

由于合并了两个 SELECT 语句，您有错误。如果用 ; 分隔它们，它应该可以工作。

   SELECT * 
     FROM states
 ORDER BY name ASC;

   SELECT c.candidate_id AS candidate_id,c.date_time_stamp AS candidate_date_time, 
          c.first_name AS first_name, c.last_name AS last_name,
          c.availability_date AS availability_date,
          c.experience_years AS experience_years,c.phone AS phone,
          c.phone_alternate AS phone_alternate,c.email AS email,c.bridge AS bridge,
          c.hot AS hot,c.submitted AS submitted,c.placed AS placed,
          sp.abbreviation AS specialty_abbreviation,jt.name AS candidate_job_type,
          s.first_name AS staff_first_name
     FROM candidates c
LEFT JOIN specialties sp
       ON sp.specialty_id=c.specialty_id
LEFT JOIN candidate_job_types jt
       ON jt.candidate_job_type_id=c.candidate_job_type_id
LEFT JOIN staff s
       ON s.staff_id=c.staff_id
    WHERE c.active=1
      AND ( CONCAT_WS(' ', c.first_name, c.last_name) LIKE '%gmail%'
         OR c.phone = 'gmail'
         OR c.phone_alternate = 'gmail'
         OR c.email = 'gmail'
          )
 GROUP BY c.candidate_id
 ORDER BY c.date_time_stamp DESC
    LIMIT 0,100;