Code: Select all
CREATE FUNCTION get_client_md5 ( cid int(10) unsigned )
RETURNS VARCHAR(32)
SELECT MD5(CONCAT_WS('|',name,number)) FROM client WHERE id = cid
;The query should return a varchar(32), not a set... what am i missing?
Moderator: General Moderators
Code: Select all
CREATE FUNCTION get_client_md5 ( cid int(10) unsigned )
RETURNS VARCHAR(32)
SELECT MD5(CONCAT_WS('|',name,number)) FROM client WHERE id = cid
;Code: Select all
CREATE FUNCTION get_client_md5 ( cid int(10) unsigned )
RETURNS VARCHAR(32)
SELECT MD5(CONCAT_WS('|',name,number)) AS return FROM client WHERE id = cid
;