MySQL has an if syntax ( if(action=2 and state=0, 1, 0) ), but case is more universal. Note that the as state there is just aliasing the column.
確定! 回上一頁