rAthus icon

Baroudeur SQL REPLACE categories > tags

rAthus | PRO | 04/25/16 03:47:45 PM UTC | 0 ⭐ | 745 👁️ | Never ⏰ | []
MySQL |

610 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
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é")
;

Comments