On May 11, 2011 7:14 PM, "John" <tauru...@gmail.com> wrote: > let's say I have a table with columns for each day of the week > > create table seven_days > (monday_value integer, > tueday_value integer, > wednesday_value integer, > ... ); > > I want to select value from whatever day it is today. So if today is > Tuesday, select from tuesday_value. > > Can I do it with pure SQlite?
Sure. First setup a view that consists of a union of queries one for each day, with a column whose value is the day of the week. Then query that view. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
