Not exactly, more like, if today's date is equal to Live_date of the latest record(s) when ORDERED by live_date, continue, otherwise get 'n' random records. I.e. we don't know the live_date a priori, I suppose this requires two calls right - one to get the live_date and compare it, and then to pull either those records or a random one, maybe it can be done in 1 but can't figure it
Subject | Author | Views | Date |
---|---|---|---|
mysql conditional selects | scorpioncapital | 2064 | Jan 26, 2005, 8:23 AM |
Re: [scorpioncapital] mysql conditional selects | Andy | 2003 | Jan 26, 2005, 9:55 AM |
Re: [Andy] mysql conditional selects | scorpioncapital | 1995 | Jan 26, 2005, 10:04 AM |