Results 1 to 5 of 5
Aug 22, 2006, 04:57 #1
Why doesn't this work? - SHOW TABLES NOT LIKE 'history%'
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.