How to write this kind of SQL in MySQL? -


I want to update the tab in a column col Whose data is as follows (separated by commas, with title commas):

 , test, oh, whatever, ....,  

Which may be too long to display, how can I update the column so that only the first 10 should be omitted?

you are looking

  updated table SET column = SUBSTRING_INDEX ( Column, ',', 11)  

(check them before selecting your updates)


Comments