SQL Randomization on Daily Basis

Question

I have an SQL listing shops, but i would like to random the results on a daily basis.

For example today I list bat 2, 6, 9 etc and tomorrow, 6,1,7,9 etc

Is there a way to implement this?

Are you trying to select random records or are you trying to randomize the resulting display? — Nate
– Nate, Commented May 24, 2010 at 19:23
i would like to random the results, but on a dialy basis. Thus if i today i run the query 10 times, the results for today will remain the same order, but if run tomorrow results should change — mouthpiec
– mouthpiec, Commented May 24, 2010 at 19:25

Nicola Cossu · Accepted Answer · 2010-05-24 20:30:40Z

1

With mysql you can write a query like this

select * from table order by rand(curdate()) limit 3

You can adapt it to other rdbms if you need.

answered May 24, 2010 at 20:30

Nicola Cossu

56.7k15 gold badges96 silver badges99 bronze badges

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

Comments

Hammerite · Accepted Answer · 2010-05-24 20:14:11Z

0

Is this for a website or...?

You could set up a cron job to run a script on a daily basis and change something to make different shops show up.

For example, you could create a table that contains the ID numbers of shops you want to show, and when your cron job runs it would delete all records from that table and insert new ones, determined randomly or however you want.

answered May 24, 2010 at 20:14

Hammerite

22.5k6 gold badges76 silver badges103 bronze badges

1 Comment

mouthpiec Over a year ago

yes this is about a website ..... i will think about this, maybe by creating a coloumn with holding a random number that will change daily.

Collectives™ on Stack Overflow

SQL Randomization on Daily Basis

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related