Tell me how to write such a SQL query? ``` SELECT IF(myTableColumn<2 OR myTableColumn>4, TRUE...

# exposed

[BorzdeG]

Tell me how to write such a SQL query?

SELECT IF(myTableColumn<2 OR myTableColumn>4, TRUE, FALSE) as myColumn FROM myTable;

[tapac]

There is not IF support in Exposed atm, but you can use `case-when-else`:

case().When(MyTable.column lt 2 or (MyTable.column gt 4), booleanLiteral(true)).Else(booleanLiteral(false))