Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Join 1 other subscriber
Replace space (“ ”) with no space (“”) in one column in mysql
I need to remove space in one column in mysql
You can use :
SELECT SUBSTRING_INDEX('TACOMA, Washington, 98477', ',', 2)
And the update statement :
SET my_col = SUBSTRING_INDEX(my_col, ',', 2)
Where you need to replace my_table with your table name and my_col with the column you need to be updated.