[Solved] NOT LIKE not working with SHOW [duplicate]

You can’t use not like directly in a show tables statement, but you could put it in a where clause:

SHOW TABLES WHERE tables_in_db NOT LIKE 'wp_2_%';