mysql global search procedure
DROP PROCEDURE IF EXISTS findAll; DELIMITER $$ CREATE PROCEDURE findAll(IN `search` TEXT) BEGIN SET SESSION group_concat_max_len := @@max_allowed_packet; SELECT GROUP_CONCAT( "SELECT '", c1.TABLE_NAME, "' AS `table`, '", c1.COLUMN_NAME, "' AS `column`, ", "CONCAT_WS(',', ", (SELECT GROUP_CONCAT(CONCAT('`', c2.column_name, '`')) FROM `information_schema`.`columns` c2 WHERE c1.TABLE_SCHEMA=c2.TABLE_SCHEMA AND c1.TABLE_NAME=c2.TABLE_NAME AND c2.COLUMN_KEY='PRI'), ") AS pri, ", "CONVERT(`", c1.COLUMN_NAME, "` USING utf8mb4) COLLATE utf8mb4_general_ci AS value FROM `", ...