Compare text in MySQL database

behavior
(David Joyce) #1

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?

(Bellave Jayaram) #2

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

(David Joyce) #3

“should” being the operative word. CONTAINS() appears to work. Thank you very much!