Can I use Index column for REGEXP queries in mySQL?
PP
You can run regexp queries on indexed columns, but MySQL will not use the index, it will do a seq. scan.
And MySQL does not support functional indexes.