I'm trying to pass a value into a stored procedure to dynamically set which column(s) to sort by. The following code doesn't work. The query executes but ignores my order by parameter. I assume there is a simple answer to this that I'm just missing.
create procedure sp_equipment_find ( IN L_ORDER_BY MEDIUMTEXT ) BEGIN SELECT * from mytable ORDER BY @L_ORDER_BY; END$ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]