在SQL中,可以使用 TRIM() 函数来去除字符串两端的空格或指定的字符。其基本语法如下:
TRIM([{BOTH | LEADING | TRAILING} [trim_character] FROM] input_string)
其中:
示例:
SELECT TRIM(' Hello ') AS trimmed_string; -- 结果为 'Hello'
SELECT TRIM(LEADING '0' FROM '00012345') AS trimmed_string; -- 结果为 '12345'
SELECT TRIM(TRAILING 'x' FROM 'xxxxHelloxxxx') AS trimmed_string; -- 结果为 'xxxxHello'