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'