May I do IF OR THEN in MySQL

Asked Nov 14 '16 at 18:14

Active Nov 14 '16 at 18:19

Viewed 45 times

In the following, there are two IF checks that dispatch to the same table_a:

SET @first = substr(new.data, 1, 1);

IF @first = 0x15 THEN

    INSERT INTO table_a (    
        id,
        time,
        data
    ) VALUES (
        new.id,
        new.time,            
        new.data
    );

ELSEIF @first = 0x16 THEN 

    INSERT INTO table_a ( 
        id,
        time,
        data
    ) VALUES (
        new.id,
        new.time,            
        new.data
    );

Is it, instead, possible to write something like?

IF @first = 0x15 | 0x16 THEN
    INSERT INTO table_a (    
        id,
        time,
        data
    ) VALUES (
        new.id,
        new.time,            
        new.data
    );

edited Nov 14 '16 at 18:19

asked Nov 14 '16 at 18:14

KcFnMi

5,516
10
62
136

You mean using `IN(...)`? – tadman Nov 14 '16 at 18:18
Not sure If I understood what you mean? – KcFnMi Nov 14 '16 at 18:19
You need to [read the documentation more](http://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html) because a lot if this is covered in there. – tadman Nov 14 '16 at 18:21

May I do IF OR THEN in MySQL

0 Answers0