<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div>You could use something like...</div><div><span style="font-family: 'Trebuchet MS', verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 14px; text-align: left; ">SELECT * FROM table WHERE TO_DAYS(col_name) = TO_DAYS(NOW())+1</span><br></div><div><span style="font-family: 'Trebuchet MS', verdana, geneva, lucida, 'lucida grande', arial, helvetica, sans-serif; font-size: 14px; text-align: left; "><br></span></div><div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-size: 10pt; font-family: arial, helvetica, sans-serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b>
Wayne Morris <waynelists@machx.co.uk><br> <b><span style="font-weight: bold;">To:</span></b> Wolverhampton Linux User Group <wolves@mailman.lug.org.uk> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, 8 March 2012, 14:52<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Wolves] Fwd: Fwd: mysql select help<br> </font> </div> <br>On 08/03/2012 14:39, Mike Hingley wrote:<br>> A cohort date sounds like duplication of data here. I think the issue - the real issue might be using a timestamp rather than a date field.<br>> <br>> How about using date_format to strip the time elrment, and group on that.<br>> <br>> The advantage there is no schema change.<br>> <br>Sorry, just checked my database and i was thinking of another field which was a timestamp - this is a simple 'date' field.<br><br>cheers<br><br>_______________________________________________<br>Wolves LUG mailing list<br>Homepage: <a
href="http://www.wolveslug.org.uk/" target="_blank">http://www.wolveslug.org.uk/</a><br>Mailing list: <a ymailto="mailto:Wolves@mailman.lug.org.uk" href="mailto:Wolves@mailman.lug.org.uk">Wolves@mailman.lug.org.uk</a><br>Mailing list home: <a href="https://mailman.lug.org.uk/mailman/listinfo/wolves" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/wolves</a><br><br><br> </div> </div> </blockquote></div> </div></body></html>