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

The MySQL syntax offers several ways to avoid repeating names in a table and to order names alphabetically. You cannot use the MySQL keyword "auto_increment" on a character-type column, ...