[Wolves] mysql select help

Wayne Morris waynelists at machx.co.uk
Tue Mar 13 01:28:27 UTC 2012


On 12/03/2012 16:56, Mark Rogers wrote:
>
>
> .. should get you the data you want.
>
> I haven't tested that!
>
You're a star! A bit of playing got:
"SELECT * FROM phonelist WHERE trydate = (SELECT trydate FROM phonelist 
WHERE trydate > DATE(NOW()) ORDER BY trydate ASC LIMIT 1 )" ;

so as I understand it the brackets return the (1) date that next occurs 
after 'NOW', the outside the brackets selects all the results on the day.

cheers

Wayne



More information about the Wolves mailing list