MySQL column with duplicate values

Question

I have a string column which has duplicate values, for example

row 1 column "desc" has value -> "stack-overflow stack-overflow"

I want to update the column to "stack-overflow"

any idea how to build a query for that?

sumit · Accepted Answer · 2013-12-01 11:11:15Z

1

duplicate record must be symmetric and should be repeated twice only then following will do the trick

select 
    left 
        (
          'stack-overflow stack-overflow',
          length('stack-overflow stack-overflow')/2
        )

answered Dec 1, 2013 at 11:05

sumit

15.5k14 gold badges75 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1