CASE WHEN THEN MYSQL EXAMPLE: DATE OF BIRTH


One simple example of MySql case statement:

This query checks  if a user is adult or not from his date of birth field:

select ID, case when ((datediff(DATE(NOW()), dob)/365)>18) then 1 else 0 end as isAdult from users; 
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s