UPDATE sql by if else -CASE, ELSE, END-

PHOTO EMBED

Sun Sep 18 2022 11:02:42 GMT+0000 (Coordinated Universal Time)

Saved by @HamzaNasro ##if_statement ##php

UPDATE tbl_users 
SET img = CASE gender 
        WHEN gender=1 THEN 'client_files/44073762e25b9fed53b/userPic/default/male.jpg' 
        WHEN gender=2 THEN 'client_files/44073762e25b9fed53b/userPic/default/female.jpg' 
        ELSE 'client_files/44073762e25b9fed53b/userPic/default/male.jpg' 
      END 
content_copyCOPY