“show tables not like” in mysql

Posted by

I was looking for the tables in my database not starting with “p_”. MySQL doesn’t let you execute this command:

Which is odd considering it will allow “like” here:

Instead, you have to use the information schema like this:

Leave a Reply

Your email address will not be published. Required fields are marked *