Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.mindsdb.com/llms.txt

Use this file to discover all available pages before exploring further.

MindsDB supports standard SQL syntax, including the CASE WHEN statement. The CASE WHEN statement is used for conditional logic within queries. It evaluates conditions and returns specific values based on whether each condition is true or false, allowing for conditional output within SELECT, WHERE, and other clauses. 
SELECT
        CASE
            WHEN a=1 THEN a+b
            WHEN 1+2=b*2 THEN 0
            WHEN (a+b>2 or b<c+3) AND a>b THEN b
            ELSE c
        END
FROM table_name;