从列 mysql 中删除所有数字字符

使用MySQL删除所有数字字符的方法

sql
CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    text_column VARCHAR(255)
);
INSERT INTO example_table (text_column) VALUES
    ('Some text with 123 numbers'),
    ('Another string without numbers'),
    ('Text 987 with mix of characters');

sql
SELECT 
    id, 
    REGEXP_REPLACE(text_column, '[0-9]', '') AS text_without_numbers
FROM 
    example_table;