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
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter