SELECT * FROM `the_table` WHERE `field1` LIKE 'string%' OR `field2` LIKE 'string%' OR `field3` LIKE 'string%' OR `field4` LIKE 'string%' OR `field5` LIKE 'string%' OR `field6` LIKE 'string%' OR ...

Sequences in MySQL help ensure that values aren't repeated, and many applications require database tables to have an incrementing "id" column. The MySQL syntax offers several ways to avoid repeating ...