CREATE TABLE `s` (
    `form` varchar(255) DEFAULT NULL,
    `freq` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`form`)
    ) DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

SELECT form FROM s LIKE "foo%" ORDER BY	   freq DESC LIMIT 30;