I am looking to develop a (seemingly) simple WFA filter that finds aggregates that match a specific pattern.

I can't seem to find specific documentation to say what WFA supports with regards to SQL queries.

I found this page:

https://library.netapp.com/ecmdocs/ECMP1644818/html/GUID-25449353-2C25-4FBB-BA36-6152D97E1D4E.html

Which has a SELECT link to mysql 5.1:

http://dev.mysql.com/doc/refman/5.1/en/select.html

I'd assume that if the WFA documentation references MySQL 5.1, that it should support REGEXP and RLIKE, but it doesnt seem that it does.

I was trying to do pattern matching: LIKE 'aggr[13][0-9]%'

Which simply translates to a string that looks like aggr10-19* or aggr30-39*. It sounds like I may need to make a 20 element OR query??