SELECT table_name,column_name
FROM information_schema.COLUMNS
WHERE table_schema = ‘your database here’
WHERE table_schema = ‘your database here’
and column_name = ‘your columname here’
searching mysql for a columnname
Leave a Comment
You must be logged in to post a comment.