Breaking News: Grepper is joining You.com. Read the official announcement!

mysql case when on date

Add Answer

Drakonkat answered on October 23, 2020 Popularity 10/10 Helpfulness 4/10

answer mysql case when on date

related mysql case when or

related mysql case when and

mysql case when on date

Comment

SELECT
  id,
  CASE
    WHEN date_activated > '2011-11-23 18:30:00' THEN 'after'
    WHEN date_activated > '2010-01-20 00:00:00' THEN 'before'
    ELSE 'not yet'
  END AS date_note
FROM table1;

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: case-when date mysql sql

Link to this answer
Share Copy Link

Contributed on Oct 23 2020

Drakonkat

0 Answers Avg Quality 2/10

Closely Related Answers

mysql case when or

Comment

SELECT
    CASE 
        WHEN
            column IS NULL OR another_column = 1
        THEN
            'yes' 
        ELSE
            'no' 
    END AS 'MyData'
FROM
    table_name;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: case-when case

Link to this answer
Share Copy Link

Contributed on Jul 05 2021

MatrixZA

0 Answers Avg Quality 2/10

mysql case when and

Comment

SELECT column1,
       CASE
           WHEN condition1 AND condition2 THEN result1
           WHEN condition3 AND condition4 THEN result2
           ELSE result3
       END
FROM your_table;

Popularity 9/10 Helpfulness 3/10 Language sql

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 11 2023

YOU.com

0 Answers Avg Quality 2/10

mysql case when on date

Contents

More Related Answers

mysql case when on date

Closely Related Answers

mysql case when or

mysql case when and

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.