mysql语句中if函数_在MySQL SELECT查询中使用IF语句

我试图在MySQL选择查询中使用IF语句。

在AND语句之后我收到一个错误，其中第一个IF。

SELECT J.JOB_ID,E.COMPANY_NAME,J.JOB_DESC,JT.JOBTYPE_NAME,J.COMPENSATION,ST.STATE_NAME,MC.METRO_CITY_NAME,I.INDUSTRY_NAME,

J.JOB_CONTACT_PERSON,J.DT_INSRT,J.JOB_TITLE,J.JOB_EXP_DATE,J.SKILLS

FROM JOBS J

JOIN EMPLOYER E ON J.COMPANY_ID=E.COMPANY_ID

JOIN LOOKUP_JOBTYPE JT ON J.JOB_TYPE=JT.JOBTYPE_ID

JOIN LOOKUP_STATE ST ON J.STATE_ID=ST.STATE_ID

JOIN JOBS_LOCATION JL ON J.JOB_ID=JL.JOB_ID

JOIN LOOKUP_METRO_CITY MC ON JL.METRO_CITY_ID=MC.METRO_CITY_ID

JOIN LOOKUP_INDUSTRY I ON J.INDUSTRY_ID=I.INDUSTRY_ID

JOIN JOBS_QUALIFICATION JQ ON J.JOB_ID=JQ.JOB_ID

JOIN LOOKUP_DEGREE_QUALIFICATION LDQ ON LDQ.QUALIFICATION_ID = JQ.QUALIFICATION_ID

WHERE J.ACTIVE='Y' AND J.DT_INSRT > COALESCE(pEmailSntDt,DATE_SUB(SYSDATE(),INTERVAL 4 DAY))

AND

IF(JQ.COURSE_ID=0)

THEN

IF(JQ.DEGREE_ID=0)

THEN J.SKILLS LIKE CONCAT('%', pSkills,'%')

ELSE

JQ.DEGREE_ID=pDegreeId OR J.SKILLS LIKE CONCAT('%', pSkills,'%')

END IF

ELSE

JQ.COURSE_ID=pCourseId OR IF(JQ.DEGREE_ID=0)

THEN

J.SKILLS LIKE CONCAT('%', pSkills,'%')

ELSE

JQ.DEGREE_ID=pDegreeId OR J.SKILLS LIKE CONCAT('%', pSkills,'%')

END IF

END IF

GROUP BY J.JOB_ID ORDER BY J.DT_INSRT DESC;

为什么这不工作，什么是在MySQL查询中执行IF语句的正确方法？