Hi,

Well my question is simple - I want to exclude tables with a certain prefix using this:

SHOW TABLES NOT LIKE 'history%'

With the prefix obviously being 'history'. I cannot understand why I get a nasty syntax error - it works when I have just LIKE rather than NOT LIKE but I want all the tables that are NOT like it.

Thanks.