NOT LIKE not working with SHOW

Question

SHOW TABLES NOT LIKE 'wp_2_%'

this sql query is not working for me

Which dbms and interface are you using. SQL itself has no SHOW command. — jarlh, Dec 29 '16 at 09:49

score 3 · Accepted Answer · answered Dec 29 '16 at 09:52

3

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_%';

answered Dec 29 '16 at 09:52

Mureinik

Sergio Tulentsev · Answer 2 · 2016-12-29T09:58:03.350

1

Yes, and it shouldn't work. SHOW TABLES simply does not allow using NOT like that.

edited Dec 29 '16 at 09:58

answered Dec 29 '16 at 09:49

Sergio Tulentsev

2 Answers2