Can anyone help me figure out how to use the visual query builder to allow users to create a LIKE statement with multiple values?
For example: select * from mytable where field1 like '%value1%' OR field1 like "%value2%'
Ideally what my users would like to do is to upload the list of values from a file (like it can be done on the IN statement), and have this populated to a LIKE statement. Can this be done in query builder?