MariaDB and MySQL are very compatible, and my examples are simple, so whenever I mention MariaDB, you can assume it applies to MySQL as well. ... (and the in-client help for MariaDB and PostgreSQL) ...

I need to search about twenty columns for given a string with wildcards. The query essentially looks like this: SELECT * FROM `the_table` WHERE ...