Is it possible to have a double LIKE in a SQL statement? If I use on one LIKE it works fine. Any suggestions on how to make it work?

SHOW TABLES WHERE Tables_in_lighthouse NOT LIKE 'tbl_list_%' OR NOT LIKE 'tbl_list_%'

Not sure if I understood what you were asking but I think you may be wanting to use an AND in place of an OR.

repeat the testing value after the OR


SELECT ... WHERE value NOT LIKE ... OR value NOT LIKE ...