select * from info where name REGEXP '^L';
select * from info where name REGEXP '^aaa';
select * from info where name REGEXP 'c$';
select * from info where name REGEXP 'aaa$';
select * from info where name REGEXP '^L..y$';
select * from info where name REGEXP '[ceo]';
select * from info where name REGEXP '[0-9]';
select * from info where name REGEXP '[0-9a-c]';
select * from info where name REGEXP 'ic';
select * from info where name REGEXP 'ic|uc|ab';
select * from info where name REGEXP 'a*c';
select * from info where name REGEXP 'a+c';
select * from info where name REGEXP 'ab{1,3}';
select * from info where name REGEXP 'a{3}';
select * from info where name REGEXP '^aaa';
select * from info where name REGEXP 'c$';
select * from info where name REGEXP 'aaa$';
select * from info where name REGEXP '^L..y$';
select * from info where name REGEXP '[ceo]';
select * from info where name REGEXP '[0-9]';
select * from info where name REGEXP '[0-9a-c]';
select * from info where name REGEXP 'ic';
select * from info where name REGEXP 'ic|uc|ab';
select * from info where name REGEXP 'a*c';
select * from info where name REGEXP 'a+c';
select * from info where name REGEXP 'ab{1,3}';
select * from info where name REGEXP 'a{3}';