SQL

mysql 명령어

pooney 2020. 1. 13. 03:17

mysql 비교문 

select if('컬럼값' = '비교값','참일때 ','거짓일 때') result   from user 

ex) select IF( id = 'hoo3' , 'true' , 'false' ) result   from user

ex) select IF( id => 'hoo3' , 'true' , 'false' ) result   from user