I am in situation where I need to keep as much logic as possible within SQLite. However the query that I need to perform does not seem to be possible to perform.
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? -- ~John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
