Sample Query Select contain Case Statement
SELECT email, Proses, tanggal_pendaftaran, date(updated_at) tglUpdate,
CASE
WHEN proses like '%Daftar%' THEN date(tanggal_pendaftaran)
WHEN proses like '%Upgrade%' THEN date(updated_at)
ELSE date(tanggal_pendaftaran)
END AS TglProses
FROM register
Leave a comment