在MySQL中替代MySQL CASE
IF()在MySQL中，使用method作为CASEWHEN的替代方法。让我们首先创建一个表-
mysql> create table DemoTable1593 -> ( -> PlayerScore int -> );
使用插入命令在表中插入一些记录-
mysql> insert into DemoTable1593 values(78); mysql> insert into DemoTable1593 values(0); mysql> insert into DemoTable1593 values(89); mysql> insert into DemoTable1593 values(0);
使用select语句显示表中的所有记录-
mysql> select * from DemoTable1593;
这将产生以下输出-
+-------------+ | PlayerScore | +-------------+ | 78 | | 0 | | 89 | | 0 | +-------------+ 4 rows in set (0.00 sec)
这是使用MySQL的查询IF()-
mysql> select if(PlayerScore=0,'',PlayerScore) from DemoTable1593;
这将产生以下输出-
+----------------------------------+ | if(PlayerScore=0,'',PlayerScore) | +----------------------------------+ | 78 | | | | 89 | | | +----------------------------------+ 4 rows in set (0.00 sec)