For MySQL, You can use IF() wherein the oracle you would have used DECODE(). mysql> select if(emp_id=1,'X','Y') as test, emp_id from emps;.
確定! 回上一頁