mysql - Select a particular type of columns that begin with a certain letter and fetch data all together -
i trying fetch data @ same time select specific type of columns i`m doing is: select column_name information_schema.columns table_name = 'table' , table_schema = 'db' , column_name 'f%' this query give me col names, there option fetch data of colum @ same time? or need take array of cols , make query? let want fetch data, doesnt matter. thanks. you can use stored procedure this, dynamic sql. first, must create stored procedure: create procedure fetchcolumns (in pschemaname char(50), in ptablename char(50), in pcolumnlikecondition char(50)) begin declare v_cols char(200); select group_concat(column_name separator ' , ') v_cols information_schema.columns table_name = ptablename , table_schema = pschemaname , column_name pcolumnlikecondition; set @s = concat('select ',v_cols,' ',ptablename ); prepare stmt @s; execute stmt; end and finally, have calling it, this...
