How to use regex in MySQL?

Question

I want to filter out those with field not like '%_[0-9]+' ,

but it turns out that MySQL doesn't take it as regex,

is that possible in MySQL?

Answer 1

That happens because of LIKE is not supposed to accept regular expression as a parameter. There is REGEXP for such things

WHERE field NOT REGEXP '%_[0-9]+'