From 1987ca5514c2b62a37a80d6fcf290334e582fdde Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 17 Nov 2014 14:50:17 +0800 Subject: [PATCH] mysql/core_enum_name_to_display_name.sql --- mysql/core_enum_name_to_display_name.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) create mode 100644 mysql/core_enum_name_to_display_name.sql diff --git a/mysql/core_enum_name_to_display_name.sql b/mysql/core_enum_name_to_display_name.sql new file mode 100644 index 00000000..f4d88826 --- /dev/null +++ b/mysql/core_enum_name_to_display_name.sql @@ -0,0 +1,14 @@ + + +DROP FUNCTION IF EXISTS core_enum_name_to_display_name; +DELIMITER $$ +CREATE FUNCTION core_enum_name_to_display_name(in_etype VARCHAR(256), in_name VARCHAR(256)) + RETURNS VARCHAR(256) DETERMINISTIC + BEGIN + DECLARE ret VARCHAR(256); + SET ret = ''; + SELECT display_name INTO ret FROM core_enum + WHERE name=in_name AND etype=in_etype LIMIT 1; + RETURN ret; + END $$ +DELIMITER ; \ No newline at end of file -- 2.39.2