I'm looking for a column in the database and rather than dig through 50 tables i was wondering if there was a *magical* query that could do the trick.

Something to the effect of
select * from (show tables) limit 1;

i saw some where to try an use the table "Syscolumns" but i get an error:
table db.Syscolumns doesn't exist

any suggestions?

thanks