When my app was based on a spreadsheet (Google sheets) I could compare text easily in a security filter.
[ColumnName] = <LOOKUP Text>
Now that I am using a mysql database the same security filter returns no rows because in the database you have to compare text like this:
ColumnName LIKE '%LOOKUP Text%'
How do I modify the AppSheet security filter so it can speak MySQL 5.6?