Knowing and Removing the Underscore Records in a table

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