C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
Knowing and Removing the Underscore Records in a table
WhatsApp
Satyapriya Nayak
11y
3.6
k
0
1
25
Blog
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, '_', '')
Knowing and removing underscore records in table
People also reading
Membership not found