How do I use properly CASE..WHEN in MySQL

Remove the course_enrollment_settings.base_price immediately after CASE:

SELECT
   CASE
    WHEN course_enrollment_settings.base_price = 0      THEN 1
    ...
    END

CASE has two different forms, as detailed in the manual. Here, you want the second form since you’re using search conditions.

Related Posts:

  1. Case statement in MySQL
  2. SQL Switch/Case in ‘where’ clause
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Case in Select Statement
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. Unknown column in ‘field list’ error on MySQL Update query
  7. MySQL – Operand should contain 1 column(s)
  8. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. MySQL create table if not exists and insert record only if table was created
  11. How can I do a FULL OUTER JOIN in MySQL?
  12. MySQL query String contains
  13. What’s the difference between VARCHAR and CHAR?
  14. How to declare a variable in MySQL?
  15. MySQL Cannot Add Foreign Key Constraint
  16. How to split the name string in mysql?
  17. How do I import an SQL file using the command line in MySQL?
  18. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  19. mysql Foreign key constraint is incorrectly formed error
  20. MySQL: Invalid use of group function
  21. How can I return pivot table output in MySQL?
  22. Compare dates in MySQL
  23. MySQL “WITH” clause
  24. MySQL Multiple Joins in one query?
  25. Error Code: 2013. Lost connection to MySQL server during query
  26. “CASE” statement within “WHERE” clause in SQL Server 2008
  27. MySQL syntax for Join Update
  28. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  29. how to drop partition without dropping data in MySQL?
  30. MySQL combine two columns into one column
  31. Simple way to calculate median with MySQL
  32. Error 1046 No database Selected, how to resolve?
  33. MySQL Error 1264: out of range value for column
  34. Remove duplicate rows in MySQL
  35. How to SUM and SUBTRACT using SQL?
  36. Cast from VARCHAR to INT – MySQL
  37. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  38. How do you force mysql LIKE to be case sensitive?
  39. MySQL – UPDATE multiple rows with different values in one query
  40. How to create a MySQL hierarchical recursive query?
  41. ERROR 1148: The used command is not allowed with this MySQL version
  42. Insert into a MySQL table or update if exists
  43. How to round down to nearest integer in MySQL?
  44. MySQL starts with searching issue
  45. Query to convert from datetime to date mysql
  46. Is it possible to GROUP BY multiple columns using MySQL?
  47. MySQL error: key specification without a key length
  48. Best way to test if a row exists in a MySQL table
  49. SQL conditional SELECT
  50. Check if MySQL table exists without using “select from” syntax?
  51. MySQL equivalent of DECODE function in Oracle
  52. mysql update column with value from another table
  53. The used SELECT statements have a different number of columns
  54. How to delete from multiple tables in MySQL?
  55. MySQL: Can’t create table (errno: 150)
  56. How to copy a row and insert in same table with a autoincrement field in MySQL?
  57. Join vs. sub-query
  58. Conditional JOIN Statement SQL Server
  59. Alternative to except in MySQL
  60. Equivalent of explode() to work with strings in MySQL
  61. ROW_NUMBER() in MySQ
  62. MySQL OPTIMIZE all tables?
  63. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  64. MySQL – Get row number on select
  65. MySQL error: Unknown column in ‘where clause’
  66. How to truncate the text returned for a column in a MySQL query
  67. Using union and order by clause in mysql
  68. MySQL LIKE IN()?
  69. SQL WITH clause example [duplicate]
  70. Must declare the scalar variable
  71. Oracle error : ORA-00905: Missing keyword
  72. Column ‘user_id’ in field list is ambiguous
  73. ORA-00972 identifier is too long alias column name
  74. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  75. Algebra Relational sql GROUP BY SORT BY ORDER BY
  76. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  77. How to store arrays in MySQL?
  78. Oracle “Partition By” Keyword
  79. Using group by on multiple columns
  80. What is the purpose of using WHERE 1=1 in SQL statements?
  81. Fatal error: Please read “Security” section of the manual to find out how to run mysqld as root
  82. How to order by with union in SQL?
  83. DATEDIFF function in Oracle
  84. How to do a batch insert in MySQL
  85. Transaction when using WP functions rather than vanilla SQL?
  86. Check if image exists before uploading with media_sideload_image()
  87. Update user_login, user_nicename, and display_name
  88. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  89. SQL Database, repeated tables?
  90. Create table from array with prepare
  91. Code to remove authors with no posts connected to them
  92. SQL Query in WordPress – Getting Impossible WHERE error
  93. Clean up very big and very dirty database
  94. SQL query injection with fifu image
  95. Why does DROP TABLE-ing the `wp_options` reset my user session?
  96. How to create index (sql) to a meta_key?
  97. Backtick (MySQL norm) added to SQL Server Query causing error
  98. Display MySQL as part of a Page
  99. SQL query to remove first image in all posts
  100. finding out the top 5 source ( source is a custom taxonomy ), in a given category

Leave a Comment