Hi All,
Quick question on SQL statements.
I’m creating a simple search within an ‘articles’ MariaDB table - it looks up three columns: subject, body, description. To get this to work correctly on the selected search query I have to use % wildcards so need to use ‘LIKE’ instead of ‘CONTAINS’ but see there is no option to do this on the ‘simple’ option in the database query manager.
I have to use ‘Custom’ method to build my queries, my question is: Would it be possible to include ‘LIKE’ as an option in the ‘Simple’ Database Query…?