Adding search_column function to mysql

Question

Is there a way to convert this query into a new function:

SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
 WHERE COLUMN_NAME IN ('current_edition') AND TABLE_SCHEMA='db_local';

where current_edition and db_local are variables so it is possible to search for a column using:

search_column('column_name', 'database');

possible duplicate of Create a dynamic mysql query using php variables — Fabio Antunes
– Fabio Antunes, Commented Jan 26, 2015 at 22:58

void · Accepted Answer · 2015-01-26 23:15:53Z

1

you want to return a table using function in MySQL as I know you can't, but you can use a procedure:

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE search_column(cl_name VARCHAR(100),db_name VARCHAR(100))
BEGIN
  SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS 
  WHERE COLUMN_NAME like cl_name 
    AND TABLE_SCHEMA=db_name;
END;

answered Jan 26, 2015 at 23:15

void

7,9403 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Adding search_column function to mysql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related