search column by name mysql

Solutions on MaxInterview for search column by name mysql by the best coders in the world

showing results for - "search column by name mysql"

1select table_name, column_name 
2from information_schema.columns 
3where column_name like '%search_keyword%'; -- change search_keyword accordingly
4

similar questions

mysql select all columns and specific fields as find column name in database mysql get only the field names in a table mysql search for column name in all tables mysql query to get column names find a column in all tables mysql mysql get column names from table mysql find tables with name get column name sql server mysql find tables with column name mysql get fields of table mysql select all table that have field names search for column name in sql db when i don 27t know which table it is in how to print out column name differently in mysql select from column mysql mysql select where field is a value search mysql database for column find tables with column name in sql find table from column name in sql mysql select columns as string mysql to get column name in database sql server search column name in all tables get table which have specific columns in mysql mysql all columns how to output a different column name in mysql search for column name in psql