July 06, 2012

Fake Names in MySQL

Here's a fun mysql snippet to replace real names with fake names on the fly.
UPDATE users

SET first_name = ELT(FLOOR(RAND()*97)+1, 'Aidan','Alexander','Asher','Andrew','Aaron','Adam','Adrian','Austin','Anthony','Braden','Benjamin','Brody','Blake','Brandon','Cayden','Caleb','Connor','Cole','Colin','Carter','Christopher','Carson','Cameron','Colton','Cooper','Dylan','Dominic','Daniel','Damien','David','Ethan','Elijah','Elliot','Evan','Emmett','Edward','Finn','Gabriel','Gavin','Grayson','Gage','Holden','Hayden','Hunter','Henry','Harry','Isaac','Ian','Isaiah','Jackson','Jacob','James','Jayden','Jack','Joshua','Jasper','Jonah','Joseph','Jonathan','Joel','John','Jude','Jason','Liam','Logan','Landon','Lucas','Levi','Luke','Mason','Matthew','Michael','Micah','Max','Miles','Maddox','Noah','Nathan','Nicholas','Nathaniel','Nolan','Oliver','Owen','Parker','Ryan','Ryder','Samuel','Sebastian','Seth','Tristan','Tyler','Thomas','William','Wyatt','Xavier','Xander','Zachary'),

last_name = ELT(FLOOR(RAND()*37)+1, 'Smith','Johnson','Williams','Jones','Brown','Davis','Miller','Wilson','Moore','Taylor','Anderson','Thomas','Jackson','White','Harris','Martin','Thompson','Garcia','Martinez','Robinson','Clark','Rodriguez','Lewis','Lee','Walker','Hall','Allen','Young','Hernandez','King','Wright','Lopez','Hill','Scott','Green','Adams','Baker')

WHERE 
1

No comments: