How to remove wildcard character from field I have fields that contain the character *. I've been trying to remove them but my commands fail with an error...

Example:

UPDATE name SET name = REGEXP_REPLACE (name, '*', '') WHERE category_id = 168;


I'm also struggling to remove other characters like |
Apparantly the quote should be \\:

UPDATE name SET name = REGEXP_REPLACE (name, '\\*', '');


Fiddle