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 ...
I'm trying to glean some info from a mysql database. Id is a product id, type, is a format of the product available (multiple versions of each id), weight is the number of downloads of that product ...