任何人都可以给我一个SELECTCASE语句的例子-cananybodypleasegivemeanexampleofSELECTwithCASEstatement

1  

This will return the same results as your updated table (however, obviously without making any changes to it):

这将返回与更新的表相同的结果(但是,显然没有对其进行任何更改):

SELECT id,
       CASE id
         WHEN 4 THEN 'Jie'
         WHEN 5 THEN 'Mie'
         WHEN 6 THEN 'Pres'
         ELSE username
       END AS username,
       CASE id
         WHEN 4 THEN 1
         WHEN 5 THEN 2
         WHEN 6 THEN 3
         ELSE status
       END AS status,
       time_mod,
       views
FROM   proba13.chat_users

0  

Try this one

试试这个

SELECT  (CASE WHEN 
    id =4 THEN 'Jie'
    WHEN id =5 THEN 'Mie'
    WHEN id =6 THEN 'Pres'
END ) `username` ,
 (CASE  WHEN 
   id= 4 THEN '1'
    WHEN  id= 5 THEN '2'
    WHEN  id= 6 THEN '3'
END ) `status`  FROM  `chat_users` 
WHERE id IN (4,5,6)