Condition for INSERT INTO

Question

I need SQL to check that in the '@variable' sent there is a value equal to 1, 2 or 3; If true enter the value 1, otherwise enter the value 0.

Note: the table and column can be given as examples as fictitious.

Answer 1

Basically this:

INSERT INTO tabela SET coluna = IF( @variavel IN (1,2,3), 1, 0 );

• The IN returns true if the variable is in the list

• The IF returns the second value if the first expression is true, or returns the third.

See working on SQL Fiddle.

Notes:

• In T-SQL from 2012, there is the function IIF, which works in the same way as IF of Mysql/Mariadb

• For other Dbs have the CASE, can see in more detail in this post:

  Return predefined values depending on logical condition

Answer 2

Using SQL Ansi, which works on all databases, you can do something like:

insert into dados (coluna1) values (
case @parametro 
   when 1 then 1
   when 2 then 1
   when 3 then 1
   else 0
end)