MySQL supports RegExp like below
select * from foo where fieldname regexp '<the pattern>' |
RegExp in MySQL is case sensitive, so you need to use a special function like lowercase or uppercase to remove case sensitivity like below:
select * from foo where lower(fieldname) regexp 'hello(.*)world' |
or
select * from foo where upper(fieldname) regexp 'HELLO(.*)WORLD' |