mysql use alternative name in switch construction

Question

I try to get select with code below

Select `admin`.`admin_id`, `admin`.`email` AS `admin_email`, IF(customer.email IS NOT NULL OR admin_email IS NOT NULL, 'Subscribed', 'Unsubscribed') AS `field_name`, (...Something else) from admin, customer, (...Something else);

Then get error #1054 - Unknown column 'admin_email' in 'field list'

Please see: [Why should I provide an MCVE for what seems to me to be a very simple SQL query?](https://meta.stackoverflow.com/q/333952/2469308) — Madhur Bhaiya, Oct 21 '18 at 12:26
Please stop using comma based Implicit joins and use [Explicit `Join` based syntax](https://stackoverflow.com/questions/44917/explicit-vs-implicit-sql-joins) — Madhur Bhaiya, Oct 21 '18 at 12:26

score 0 · Answer 1 · answered Oct 21 '18 at 12:51

You can not use alias in the if statement, so

Select admin.admin_id, admin.email AS admin_email, IF(customer.email IS NOT NULL OR admin.email IS NOT NULL, 'Subscribed', 'Unsubscribed') AS field_name, (...Something else) from admin, customer, (...Something else);

mysql use alternative name in switch construction

1 Answers1