Skip to content

Instantly share code, notes, and snippets.

@dody87

dody87/set_random_profile_image.sql

Created March 31, 2019 15:42
Show Gist options
  • Save dody87/d723642baf32bc64caeca7ec2dd1d6e0 to your computer and use it in GitHub Desktop.
Save dody87/d723642baf32bc64caeca7ec2dd1d6e0 to your computer and use it in GitHub Desktop.
Download ZIP
set_random_profile_image.sql
Raw
set_random_profile_image.sql
UPDATE user
SET img = REPLACE('https://randomuser.me/api/portraits/men/?.jpg', '?', FLOOR((RAND() * (50-20+1))+20))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment