ALTER TABLE `blah` COMMENT = 'this is for testing' Can be seen with: SHOW CREATE TABLE `blah`;
With MySQL 5.0.x there is a `information_schema` database as well as the `mysql` database. These table comments are stored in: `information_schema`.`tables`.`table_comment`
Simply query this database/table or join with another query. Hope that helps. -- Ritter _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
