inboxHub
Login
Signup
x
Login
Signup
Home
Categories
Application
Artificial Intelligence
Database
Digital Marketing
Physiotherapy
Quality Assurance
Web Technology
Home
Remove-first-string-from-field-in-mysql
Remove first string from field in mysql
I"m trying to remove the first two characters for each row in mysql
Deepak Sharma
Asked 20-11-2024
127
Answer (1)
here is the code for remove first character from string of column data;
UPDATE table1
SET column1 = SUBSTRING_INDEX(column1 , "-",-1);
Ankur Rajput
Asked 09-11-2019
45 Likes
Comments
Write comment
Submit
Submit your answer