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

mysql case

Add Answer

Friendly Hawk answered on July 6, 2020 Popularity 10/10 Helpfulness 5/10

answer mysql case

related mysql case when or

related mysql switch case

related Case in select for MySQL

related case in mysql

related mysql case when and

mysql case

Comment

 select 
(CASE
	WHEN (market_cap < 300000000) THEN 'micro'
	WHEN (market_cap < 2000000000) THEN 'small'
	WHEN (market_cap < 10000000000) THEN 'mid'
	WHEN (market_cap < 50000000000) THEN 'large'
ELSE 'mega'
END) AS `cap_type`
from companies;

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: case mysql sql

Link to this answer
Share Copy Link

Contributed on Jun 29 2022

Friendly Hawk

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 switch case

Comment

SELECT 
t2.company_name,
t2.expose_new,
t2.expose_used,
t1.title,
t1.status,
 CASE status
   when 'New' and t2.expose_new = 1 then 1
   when 'New' and t2.expose_new = 2 then 2
   when 'New' and t2.expose_new = 3 then 3
   when 'Used' and t2.expose_used = 1 then 1
   when 'Used' and t2.expose_used = 2 then 2
   when 'Used' and t2.expose_used = 3 then 3
END as expose
FROM `products` t1
join manufacturers t2 on t2.id = t1.seller
where t1.seller = 4238

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: case

Link to this answer
Share Copy Link

Contributed on Jul 06 2020

Matteoweb

0 Answers Avg Quality 2/10

Case in select for MySQL

Comment

SELECT 
CASE 
    WHEN inty = 0 then 'No'
    WHEN inty = 1 then 'Yes'
    ELSE 'Maybe'
END
AS InternetApproved
FROM Table1

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: case

Link to this answer
Share Copy Link

Contributed on Apr 25 2023

Xerothermic Xenomorph

0 Answers Avg Quality 2/10

case in mysql

Comment

SELECT 
CASE WHEN COUNT(user_p_id) > 1 
	THEN CONCAT('Multiple Clients (', COUNT(user_p_id),')')
	ELSE client_name 
	END AS client_name, client_email
FROM user_profile
LEFT JOIN users ON (user_p_id = user_id)

Popularity 10/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: case

Link to this answer
Share Copy Link

Contributed on Dec 12 2022

@CodeGrepperManu

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 2/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

Contents

More Related Answers

mysql case

Closely Related Answers

mysql case when or

mysql switch case

Case in select for MySQL

case in mysql

mysql case when and

Grepper

Documentation

Social

Legal

Contact

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