How can I find all the tables in MySQL with specific column names in them?

by

To get all tables with columns columnA or ColumnB in the database YourDatabase:

SELECT DISTINCT TABLE_NAME 
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE COLUMN_NAME IN ('columnA','ColumnB')
        AND TABLE_SCHEMA='YourDatabase';

More Related Contents:

  1. MySQL disable all triggers
  2. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Usage of MySQL’s “IF EXISTS”
  5. Using union and order by clause in mysql
  6. Binary Data in MySQL [closed]
  7. mysql -> insert into tbl (select from another table) and some default values [duplicate]
  8. Convert MySQL schema to Github Wiki?
  9. mysql select from n last rows
  10. Install MySQL on Ubuntu without a password prompt
  11. Exporting results of a Mysql query to excel?
  12. Capitalize first letter of each word, in existing table
  13. use mysql SUM() in a WHERE clause
  14. A constraint to prevent the insert of an empty string in MySQL
  15. Search all columns of a table using a single where condition with single keyword in mysql
  16. MySQL trigger to update a field to the value of id
  17. How to get a list of MySQL views?
  18. Case statement in MySQL
  19. MySQL: Inner join vs Where [duplicate]
  20. Selecting from two tables with inner join and limit [duplicate]
  21. MySQL substring extraction using delimiter
  22. Convert Unix timestamp into human readable date using MySQL
  23. Why the order of evaluation for expressions involving user variables is undefined?
  24. MySQL : retrieve a large select by chunks
  25. MySQL – insert data from another table merged with constants
  26. How to SELECT by MAX(date)?
  27. MySQL matching unicode characters with ascii version
  28. Xampp-mysql – “Table doesn’t exist in engine” #1932
  29. Unserialize through query at database level itself
  30. Detecting utf8 broken characters in MySQL

Leave a Comment