Regex is not supported in sql command with condition "contains"

Question

I am not a seasonal Windows user, I have a task in which I had to query the Window ie index table lookup table " Systemindex " to get some user data from db.

And for this, I have to match the pattern with mostly regex when retrieving data.

SELECT System.FileName, System.ItemPathDisplay, System.DateCreated, System.DateModified, System.ItemName, System.KindText FROM Systemindex WHERE Contains('"(?=^[A-Za-z\d!@#\$%\^&\*\(\)_\+=]{9,32}$)"');

The above will allow us to search for passwords with saved passwords.

But when I request db using the command below, I get an error. And later I found out that the “contains” position does not support regex. Is there an alternative to achieving this?

Answer 1

there is a REGEXP statement http://dev.mysql.com/doc/refman/5.7/en/regexp.html , use smth like this

SELECT * FROM Systemindex WHERE some_column REGEXP 'your_regex'