1
You've got Questions? We've got Answers! / Search text in column header
« on: March 10, 2018, 09:55:50 PM »
Hi All,
I am using SQLite and have to create a query where I have to first search and select a column on the basis of some text in its header and then run mathematical operations on the data in that column. Like one column header has some text and a part of which is the day Friday. So I should be able to use something like, like '%Friday%' and then suppose count all the numbers under that column. Is there any way to do so?
Thanks in Advance
I am using SQLite and have to create a query where I have to first search and select a column on the basis of some text in its header and then run mathematical operations on the data in that column. Like one column header has some text and a part of which is the day Friday. So I should be able to use something like, like '%Friday%' and then suppose count all the numbers under that column. Is there any way to do so?
Thanks in Advance