mysql: remove duplicates that also contains a break space -

by mistake did insert in mysql rows contains duplicates, these duplicates not recognized because contain brak space

    eg.       | id | name    |        --------------       |  1 | apple   |       |  2 | apple{b}| //the {b} show cell contains break space 

so when try remove duplicates not recognized duplicates... , when try remove breaks error because name unique cell

what's best practice fix issue?

you can use regular expressions find or delete records containing space in end:

delete your_table name regexp '\s+$';