[Wolves] mysql select help

[Wayne Morris]

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