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_%';
More Related Contents:
- How can I fix MySQL error #1064?
- With MySQL, how can I generate a column containing the record index in a table?
- MySQL and GROUP_CONCAT() maximum length
- What data type to use for hashed password field and what length?
- Which is faster: multiple single INSERTs or one multiple-row INSERT?
- MySQL pagination without double-querying?
- MySQL convert date string to Unix timestamp
- How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
- Using an Alias in SQL Calculations
- MySql Table Insert if not exist otherwise update
- How to get difference between two dates in months using MySQL query?
- MySQL – Control which row is returned by a group by
- Can MySQL replace multiple characters?
- Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
- My MySQL trigger doesn’t work, simple syntax, not complicated
- Using ORDER BY and GROUP BY together
- How can VBA connect to MySQL database in Excel?
- MySQL Pivot Table Column Data as Rows
- updating columns with a sequence number mysql
- Select a column with a keyword name
- Sum results of a few queries and then find top 5 in SQL
- Select all months within given date span, including the ones with 0 values
- ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
- Use Composite Primary Key as Foreign Key
- MySql Query Replace NULL with Empty String in Select
- how to trim leading zeros from alphanumeric text in mysql function
- What are the max number of allowable parameters per database provider type?
- How to handle a query with special characters / (forward slash) and \ (backslash)
- Does MySQL support historical date (like 1200)?
- mySQL query to search all tables within a database for a string?