REGEXP case insensitive SQL QUERY

[Bala Balaravi]

How can I use REGEXP case insensitive SQL QUERY

Ex: select * from table where a REGEXP 'abc' will match both 'abc' and 'ABC'