Loading

Knowing and Removing the Underscore Records in a table

Satyapriya Nayak

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

Comments

Join the conversation! Your thoughts help the community grow.