[Wolves] mysql select help

[Andy D'Arcy Jewell]

On 08/03/12 12:24, Andy D'Arcy Jewell wrote:
> If the field is a timestamp you can say something like:
>
> select * from mydb where timestamp >= now();
>
> or:
>
> select * from mydb where timestamp >= ref_date;
>
> Or did I misunderstand your query?
>

Re-reading your query, maybe this would help:

select count(*) from mydb where timestamp = ref_date;

-- 
Andy D'Arcy Jewell

SysMicro Limited
Linux Support
T:  0844 9918804
M:  07961605631
E:  andy.jewell at sysmicro.co.uk
W:  www.sysmicro.co.uk