Knowing and Removing 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, '_', '')