MYSQL Find similar strings that differs only for a hypen or extra space

Asked Aug 03 '16 at 15:25

Active Aug 03 '16 at 15:25

Viewed 13 times

I'd like to clean up my db of products because I noticed I have labels like Model X100 and Model X-100 or Model X 100 The entries were user generated content so i didn't have much control in the old days.

I wonder if there is a way to SELECT in MYSQL those rows that are 99% similar but for an hypen or extra space

asked Aug 03 '16 at 15:25

Francesco

24,839
29
105
152

im not talking about that. how can I FIND THEM ALL not just one by one – Francesco Aug 03 '16 at 15:56
`SELECT MAX(productName) FROM table GROUP BY REPLACE(REPLACE(productName, ' ', ''), '-', '')` – Tyler Roper Aug 03 '16 at 16:00

MYSQL Find similar strings that differs only for a hypen or extra space

0 Answers0