BEGIN set @stmt_text := concat('select * from audit order by ', sorder); prepare stmt_handle from @stmt_text; execute stmt_handle; deallocate prepare stmt_handle; END $$ DELIMITER ; Subject Views Written By Posted Stored Procedure with a "ORDER BY" parameter ...