In this blog we will know how to find and remove the underscore records in a table.
To find the underscore records in table
SELECT sname FROM student WHERE (sname LIKE '%|_%%' ESCAPE '|')
Or
SELECT * FROM student WHERE sname LIKE '%[_]%'
To remove the underscore records in table
UPDATE student SET sname = REPLACE(sname, '_', '')