Baroudeur SQL REPLACE categories > tags

UPDATE bars SET tags =
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
    REPLACE(
        categorie
    ,'20',"Concert")
    ,'19',"Bar à champagne")
    ,'18',"Shisha")
    ,'17',"Cocktails")
    ,'16',"Boîte lesbienne")
    ,'15',"Boîte gay")
    ,'14',"Tapas")
    ,'13',"Théâtre")
    ,'12',"Shooters")
    ,'11',"Club")
    ,'10',"Pub")
    ,'9',"Vin")
    ,'8',"Bar")
    ,'7',"Lesbien")
    ,'6',"Gay")
    ,'5',"Lounge")
    ,'4',"Danse")
    ,'3',"Bières")
    ,'2',"Festif")
    ,'1',"Café")
;