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
Post a Comment