SQLのif条件文の詳細
459 ワード
きほんけいしき
例:
IF
IF( expr1 , expr2 , expr3 )
expr1 TRUE, expr2
expr1 FALSE, expr3
例:
SELECT IF(TRUE,2,3);
-> 2
SELECT IF(FALSE,2,3);
-> 3
SELECT IF(STRCMP("111","222")," "," ");
->
select *,if(book_name='java',' ',' ') as product_status from book where price =50
: 50 , java , ,