You need to query the information_schema database, for this and your other posts. Can I suggest you install a graphical front end for MySQL (I'd recommend HeidiSQL[^]) - apart form showing you all you need to know about this, you can view the SQL it uses to query the database in it's output window.
