Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

IF

Syntax

SQL

IF(condition, value_if_true, value_if_false)

Arguments

Any SQL objects

Return Type

Returns a value based on a specified condition.

Examples

Create a table and insert values:

SQL

CREATE TABLE orders(comp_id INT(10), comp_name VARCHAR(50), 
  order_number INT(10), order_total INT(10));

INSERT INTO orders VALUES("64","Wolf-Conn","4722","9"),
("924","Blick, Von and Lynch","9610","52"),
("487","Sipes-Bauch","5180","14"),
("835","Shields-Kiehn","7961","684"),
("476","Bogisich, Brown and Hessel","4687","482"),
("809","Cole-Durgan","9358","467"),
("232","Towne LLC","3774","445");

Create a query using the IF function:

SQL

SELECT order_number,
       comp_id,
       order_total,
       IF(order_total > 100, 'Yes', 'No') AS amount_greater_than_100
FROM orders;

+--------------+---------+-------------+-------------------------+
| order_number | comp_id | order_total | amount_greater_than_100 |
+--------------+---------+-------------+-------------------------+
|         4687 |     476 |         482 | Yes                     |
|         9358 |     809 |         467 | Yes                     |
|         5180 |     487 |          14 | No                      |
|         3774 |     232 |         445 | Yes                     |
|         7961 |     835 |         684 | Yes                     |
|         4722 |      64 |           9 | No                      |
|         9610 |     924 |          52 | No                      |
+--------------+---------+-------------+-------------------------+

IF

On this page