用MySQL写怎么删除字母_mysql – 如何从字符串中删除所有非字母数字字符？

这些答案都不适合我。我不得不创建我自己的函数叫做alphanum，它剥离了我的字符：

DROP FUNCTION IF EXISTS alphanum;

DELIMITER |

CREATE FUNCTION alphanum( str CHAR(32) ) RETURNS CHAR(16)

BEGIN

DECLARE i, len SMALLINT DEFAULT 1;

DECLARE ret CHAR(32) DEFAULT '';

DECLARE c CHAR(1);

SET len = CHAR_LENGTH( str );

REPEAT

BEGIN

SET c = MID( str, i, 1 );

IF c REGEXP '[[:alnum:]]' THEN

SET ret=CONCAT(ret,c);

END IF;

SET i = i + 1;

END;

UNTIL i > len END REPEAT;

RETURN ret;

END |

DELIMITER ;

现在我可以做：

select 'This works finally!', alphanum('This works finally!');

我得到：

+---------------------+---------------------------------+

| This works finally! | alphanum('This works finally!') |

+---------------------+---------------------------------+

| This works finally! | Thisworksfinally |

+---------------------+---------------------------------+

1 row in set (0.00 sec)

欢呼！