By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE Feedback (
Comments VARCHAR(100)
);
hank's For U@r U-pd"ate
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'hank's For U@r U-pd"ate' at line 1
INSERT INTO Feedback VALUES
('Thanks For U@r U-pd"ate');
SELECT REGEXP_REPLACE(Comments, '[^[:alnum:][:space:]]+', '')
FROM Feedback
| REGEXP_REPLACE(Comments, '[^[:alnum:][:space:]]+', '') |
|---|
| Thanks For Ur Update |