How can I remove duplicate numbers containing text?

Posted by FlexSharp on Stack Overflow See other posts from Stack Overflow or by FlexSharp
Published on 2010-03-16T09:09:08Z Indexed on 2010/03/16 9:16 UTC
Read the original article Hit count: 130

Filed under:

I have a table that looks like this:

|StreetName NR| NR |
|Teststreet 34| 34 |

How can i delete only the number in Streetname when it is the same in NR??

© Stack Overflow or respective owner

Related posts about mysql