it's me eden

eden firmansyah's page


Case on SQL select

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