Compare text in MySQL database

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?

0 2 386
2 REPLIES 2

AFAIK, security filters should not change based on data source. Have you tried using CONTAINS() ?

โ€œshouldโ€ being the operative word. CONTAINS() appears to work. Thank you very much!

Top Labels in this Space