How do write IF ELSE statement in a MySQL query

by

You probably want to use a CASE expression.

They look like this:

SELECT col1, col2, (case when (action = 2 and state = 0) 
 THEN
      1 
 ELSE
      0 
 END)
 as state from tbl1;

More Related Contents:

  1. MySQL: update a field only if condition is met
  2. Using an IF Statement in a MySQL SELECT query
  3. Count with IF condition in MySQL query
  4. get first occurrence of last changed value of a column [closed]
  5. MySQL – Rows to Columns
  6. ROW_NUMBER() in MySQL
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. Creating a “Numbers Table” in MySQL
  9. MYSQL Select MAX Date inside a join statement
  10. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  11. Determine which MySQL configuration file is being used
  12. JavaFX MySQL connection example please
  13. mysql select int as currency or convert int to currency format?
  14. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  15. Why do results from a SQL query not come back in the order I expect?
  16. MySQL combine two columns and add into a new column
  17. MySql difference between two timestamps in days?
  18. Is there a naming convention for MySQL?
  19. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  20. How to set a MySQL row to READ-ONLY?
  21. Finding number position in string
  22. Why does MySQL autoincrement increase on failed inserts?
  23. error code 1292 incorrect date value mysql
  24. How to search for rows containing a substring?
  25. Import CSV to Update only one column in table
  26. Error in MySQL library for Node.js
  27. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. MySQL data directory location

Leave a Comment