searching mysql for a columnname

February 27th, 2009 § 0

SELECT table_name,column_name
FROM  information_schema.COLUMNS
WHERE table_schema = ‘your database here’
and column_name = ‘your columname here’

Related posts:

  1. Pdo get column names

Tagged:

§ Leave a Reply

What's this?

You are currently reading searching mysql for a columnname at westworld: a webmasters best friend.

meta

  • Author: westworld
  • Comments: No Comments
  • Categories: MySQL