Feature #14718
closed
Prepared Statement: QLEFT(), QRIGHT()
Added by Carsten Rose almost 2 years ago.
Updated almost 2 years ago.
Description
Eine Funktion, vergleichbar mit LEFT, RIGHT, die wenn der String laenger ist als len, diesen abschneidet und '...' anhaengt.
# Routine name: QRIGHT
# Parameters: input text, maxlen int
BEGIN
DECLARE output TEXT;
IF maxlen < 1 THEN
SET maxlen = 1;
END IF;
IF CHAR_LENGTH(input) > maxlen THEN
SET output = INSERT(input, maxlen+1, CHAR_LENGTH(input)-maxlen, '...');
ELSE
SET output = input;
END IF;
RETURN output;
END
# Routine name: QLEFT
# Parameters: input text, maxlen int
BEGIN
DECLARE output TEXT;
IF maxlen < 1 THEN
SET maxlen = 1;
END IF;
IF CHAR_LENGTH(input) > maxlen THEN
SET output = INSERT(input, 1, CHAR_LENGTH(input)-maxlen, '...');
ELSE
SET output = input;
END IF;
RETURN output;
END
- Tracker changed from Support to Feature
- Status changed from New to Closed
- % Done changed from 0 to 100
- Target version changed from 385 to 22.9.1
Also available in: Atom
PDF