Create procedure to evaluate an input parameter in mysql with regex

Question

I need to pass a parameter for a hex color to a procedure and evaluate to make sure it is a valid hex color.

This is the regex:

select '#008000' REGEXP '^#[0-9A-F]{6}$' as `ishexcolor`;

It needs to be inserted in this procedure:

BEGIN

INSERT INTO refdata.Color(`colorCode`, `notes`)
VALUES (_colorCode, _notes);

END$$

I am new to MySQL and not familiar with the syntax. Any help?

user10176607 · Accepted Answer · 2019-03-16 20:03:44Z

1

Figured out the solution:

BEGIN
    IF _colorCode REGEXP '^#[0-9A-F]{6}$' = 1 THEN
        INSERT INTO refdata.Color(ColorCode, notes)
        VALUES (_colorCode, _notes);
    END IF;
END

answered Mar 16, 2019 at 20:03

user10176607

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create procedure to evaluate an input parameter in mysql with regex

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related