Table of regexps [MySql]

gistfile1.sql

INSERT INTO `regexp_table` (`id`, `name`, `regexp`)
VALUES
	(1,'first','pi|apa'),
	(2,'second','^(pi|apa)$'),
	(3,'third','^(pi)*$'),
	(4,'fourth','^Ba?n');


select * from regexp_table;

select T.name, T.`regexp`
from regexp_table T
where (select 'pi' REGEXP T.`regexp`) = 1;

RESULT:
first	pi|apa
second	^(pi|apa)$
third	^(pi)*$