mysql - Regex not supported in sql command with "contains" clause -

i not seasonal windows user, got task wherein had query window index search table i.e "systemindex" fetching user specific data db.

and have match pattern regular expression while fetching data.

select system.filename, system.itempathdisplay, system.datecreated, system.datemodified, system.itemname, system.kindtext systemindex contains('“(?=^[a-za-z\d!@#\$%\^&\*\(\)_\+=]{9,32}$)”'); 

the above allow search stored passwords.

but when query db using below command getting error. , later came know "contains" clause not support regular expression. there alternative achieve this?

there regexp operator http://dev.mysql.com/doc/refman/5.7/en/regexp.html, use smth this

select * systemindex some_column regexp 'your_regex'