Sent: Monday, March 15, 2010 12:58 AM
> To: mysql@lists.mysql.com
> Subject: udf return column name not value
>
> CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
> RETURNS varchar(50) DETERMINISTIC
> READS SQL DATA
> begin
> declare retval varchar(50);
> retur
, 2010 12:58 AM
To: mysql@lists.mysql.com
Subject: udf return column name not value
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
RETURNS varchar(50) DETERMINISTIC
READS SQL DATA
begin
declare retval varchar(50);
return retval;
end;
I want get value of related column but it return column name
CREATE FUNCTION getcolumnvalue(id int,columnname varchar(30))
RETURNS varchar(50) DETERMINISTIC
READS SQL DATA
begin
declare retval varchar(50);
select columnname into retval from user where ID = id ;
return retval;
end;
I want get value of related column but it return column name.
ex:- ('tom' wha
