How to get only tables, not views using SHOW TABLES?

show full tables where Table_Type="BASE TABLE"

verbatim.

Or put another way;

show full tables where Table_Type != 'VIEW'

http://dev.mysql.com/doc/refman/5.0/en/show-tables.html