Knowing and removing underscore records in table

SELECT sname
FROM student
WHERE (sname LIKE '%|_%%' ESCAPE '|')


UPDATE student SET sname = REPLACE(sname, '_', '')