带案例的Mysql查询

Question

SELECT *, CASE
    WHEN paydatefinal IS NULL OR paydatefinal = '0000-00-00' THEN paydate
    ELSE    paydatefinal END AS `paydatefinColumn`
FROM
    `ws_crm_comenzi`
WHERE
    `sezonId` = '4'
AND `service_id` = '1'
AND `finished` = '1'
 AND `paydatefinColumn`='2016-09-26'
ORDER BY `paydatefinColumn` DESC

how can i make an AND From An Column (paydatefinColumn) that is made in a case but in table this column dose't exist

Answer 1

Since that generated column is rather lengthy and you cannot use a generated column in a where clause, the easiest perhaps to wrap the whole thing in another select

SELECT * FROM (

    SELECT *, CASE
        WHEN paydatefinal IS NULL OR paydatefinal = '0000-00-00' THEN paydate
        ELSE    paydatefinal END AS `paydatefinColumn`
    FROM
        `ws_crm_comenzi`
    WHERE
        `sezonId` = '4'
    AND `service_id` = '1'
    AND `finished` = '1'
     AND `paydatefinColumn`='2016-09-26'
    ORDER BY `paydatefinColumn` DESC)

 AS A WHERE paydatefinColumn = whatever