Results 1 to 3 of 3
Thread: string comparison question
Nov 11, 2012, 10:42 #1
- Join Date
- Sep 2008
- 0 Post(s)
- 0 Thread(s)
string comparison question
been away for a while and am obviously rusty.
Please assume 'today' is Saturday.
I am trying to output the days on which a product is available either side of today. So it could be Thursday and Tuesday. I have tried using the following query to return the max(day_of_week) before today - which is in fact Friday but, it returns 'Monday'.
here's the table
CREATE TABLE `product_times` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_on_sale_id` bigint(20) NOT NULL, `day_of_week` varchar(12) COLLATE utf8_unicode_ci DEFAULT NULL, `time_of_day` time DEFAULT NULL, `max_spaces` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL, `spaces_sold` int(11) DEFAULT NULL, `remaining_spaces` varchar(6) COLLATE utf8_unicode_ci DEFAULT NULL, `on_off` char(3) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `product_on_sale_id` (`product_on_sale_id`,`day_of_week`,`time_of_day`), CONSTRAINT `productTimes_productsOnSale_fk` FOREIGN KEY (`product_on_sale_id`) REFERENCES `products_on_sale` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1985 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
and the query
I can't seem to work out what I think should be easy.