Come utilizzare case + esempio di codice mysql

Indaghiamo il mondo online per darti la risposta al tuo dilemma, in caso di domande lasciaci il dubbio e ti risponderemo con piacere.

Esempio 1: caso mysql

--LABELMOVIELENGTH 
select title, length,CASE 
	 when length <50 then 'very short film'
     when length <90 then 'short film'
     when length <120 then 'medium length film'
     when length >120 then 'long film'else'unknown length'END--AS film_length
from film;--SAMEASABOVEBUTONACUSTOMNAMEDCOLUMN
select title, length,CASE 
	 when length <50 then 'very short film'
     when length <90 then 'short film'
     when length <120 then 'medium length film'
     when length >120 then 'long film'else'unknown length'ENDAS film_length
from film;--RESULT+-----------------------------+--------+--------------------+|title|length|film_length|+-----------------------------+--------+--------------------+|ACADEMYDINOSAUR|86|shortfilm||ACEGOLDFINGER|48|very short film||ADAPTATIONHOLES|50|shortfilm||AFFAIRPREJUDICE|117|medium length film||AFRICANEGG|130|longfilm||AGENTTRUMAN|169|longfilm||AIRPLANESIERRA|62|shortfilm||AIRPORTPOLLOCK|54|shortfilm||ALABAMADEVIL|114|medium length film||ALADDINCALENDAR|63|shortfilm||ALAMOVIDEOTAPE|126|longfilm||ALASKAPHANTOM|136|longfilm||ALIFOREVER|150|longfilm||ALICEFANTASIA|94|medium length film||ALIENCENTER|46|very short film|

Esempio 2: mysql switch case

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 3ENDas expose
FROM`products` t1
join manufacturers t2 on t2.id = t1.seller
where t1.seller =4238

Ricorda che sei autorizzato a dire se fosse necessario.

---

---

Utilizzate il nostro motore di ricerca