Is there a way to generate random number in mysql and append on a string?

Question

I want to write a query that generates a number 1 - 1000 and inserts it into an email address, where that email is an empty string. I know the syntax is off, but can MySQL generate a random number that I can insert into a string to create an email such as [email protected]?

The update statement I'm looking for would be a query like this:

UPDATE contacts SET email = 'na@na' + random_number(1-1000) + '.com' WHERE email = '';

So this is where all the spam is coming from? foo123@, foo345@, etc? — Rick James
– Rick James, Commented May 7, 2017 at 3:21

Matt Elhotiby · Accepted Answer · 2011-06-19 00:24:19Z

7

I did this

 CONCAT("na@na", RAND() * 100 , '.com')

answered Jun 19, 2011 at 0:24

Matt Elhotiby

44.2k91 gold badges225 silver badges328 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JamesHalsall Over a year ago

combine it with ABS() to get rid of the float... CONCAT("na@na", ABS(RAND() * 100), '.com')

Matt Elhotiby Over a year ago

thanks i noticed that was an issue and i used CONCAT("na@na", ROUND(RAND() * 10000) , '.com')

CTala Over a year ago

I was using double concat, I did not know that I could put more than one string. Thanks for the answer !

Collectives™ on Stack Overflow

Is there a way to generate random number in mysql and append on a string?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related