MySQL query with time and random selecting

Question

I'd like to know how to how to make a query that does this:

I have a table like this:

CREATE TABLE `sendingServers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `address` text NOT NULL,
  `token` text NOT NULL,
  `lastPoll` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

And I'd like to get the following:

Select all servers where lastPoll is less then X seconds ago
Then select a random entry from the return value

Is this possible ? How do I achieve that ?

Funk Forty Niner · Accepted Answer · 2016-07-24 15:48:14Z

4

You can use something like this:

select * from `sendingServers`
where  `lastPoll` > DATE_SUB(NOW(), INTERVAL 30 SECOND) 
order by rand() limit 1

edited Jul 24, 2016 at 15:48

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Jul 24, 2016 at 15:33

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

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

Collectives™ on Stack Overflow

MySQL query with time and random selecting

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related