UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sqlite Full Text Search Query Puzzle    
 
   
Kamulegeya
post May 16 2014, 05:11 AM
Post#1



Posts: 1,767
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


Hello UA.
I have data in format yyyy-MM-dd hh:mm:ss. It is stored as text.
I want a query that matches a given day .
E.g
CODE
Select * from test where test Match '2014-03-30*'

When i try that, it returns all data excluding that of March 2014.
If i try
CODE
Select * from test where test Match '2014-04-30*'

When i try that, it returns all data excluding that of April 2014.
I am puzzled!...i am getting the opposite of what i want!
Any reason for the strange behavior?
Go to the top of the page
 
Kamulegeya
post May 20 2014, 06:44 AM
Post#2



Posts: 1,767
Joined: 5-September 10
From: Kampala,Uganda The Pearl of Africa


I got the answer here...
http://stackoverflow.com/questions/2369667...ch-query-puzzle
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 01:41 AM