Using an IF Statement in a MySQL SELECT query

by

The IF/THEN/ELSE construct you are using is only valid in stored procedures and functions. Your query will need to be restructured because you can’t use the IF() function to control the flow of the WHERE clause like this.

The IF() function that can be used in queries is primarily meant to be used in the SELECT portion of the query for selecting different data based on certain conditions, not so much to be used in the WHERE portion of the query:

SELECT IF(JQ.COURSE_ID=0, 'Some Result If True', 'Some Result If False'), OTHER_COLUMNS
FROM ...
WHERE ...

More Related Contents:

  1. How do write IF ELSE statement in a MySQL query
  2. MySQL floating point comparison issues
  3. MySQL: update a field only if condition is met
  4. Count with IF condition in MySQL query
  5. NOT LIKE not working with SHOW [duplicate]
  6. MySQL – Rows to Columns
  7. ROW_NUMBER() in MySQL
  8. How to define a custom ORDER BY order in mySQL
  9. How can I temporarily disable a foreign key constraint in MySQL?
  10. How to get the number of days of difference between two dates on MySQL?
  11. MYSQL Select MAX Date inside a join statement
  12. In SQL, how to select the top 2 rows for each group
  13. TRIGGERs that cause INSERTs to fail? Possible?
  14. Mysql query to dynamically convert rows to columns on the basis of two columns
  15. MySQL: #126 – Incorrect key file for table
  16. How to save MySQL query output to excel or .txt file? [duplicate]
  17. MySQL: Set user variable from result of query
  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. group by range in mysql
  26. MySQL GROUP BY age range including null ranges
  27. MySQL update statement to store ranking positions
  28. Best tool for synchronizing MySQL databases [closed]
  29. Failed building wheel for mysql-python
  30. How to convert a varchar column type to date type without losing the dates

Leave a Comment