Select and Update MAC Addresses to Same Format

4 votes

1 answer

1512 views

                          I have a mysql database with a macaddress column, this contains thousands of mac addresses in various formats; uppercase, lowercase and with colons. See below for an example;

    +-------------------+
    | macaddress        |
    +-------------------+
    | 90CCAADD3341      |
    +-------------------+
    | 90:3f:ff:11:22:33 |
    +-------------------+
    | 33:44:aa:bb:34:6a |
    +-------------------+
    | 8801abcd3231      |
    +-------------------+

Is there any way I can bulk update all rows in this column so they are in the same format?

I'd like them all to be uppercase with no colons, see below;

    +--------------+
    | macaddress   |
    +--------------+
    | 90CCAADD3341 |
    +--------------+
    | 903FFF112233 |
    +--------------+
    | 3344AABB346A |
    +--------------+
    | 8801ABCD3231 |
    +--------------+

How can I achieve this?
                        

Asked by TheOrdinaryGeek (177 rep)

Oct 31, 2019, 10:11 AM
Last activity: Oct 31, 2019, 10:26 AM

Select and Update MAC Addresses to Same Format

Related Questions