pysqlite smart search

klia alwaseem307ster at
Mon Feb 23 08:03:13 EST 2009

klia wrote:
>  Hey guys;
> I am trying to develop a tiny program using python to search inside sqlite
> database with file extension is .db in which the program will ask users to
> enter their search query and base on that it will retrieve the results But
> I need the program to have some smartness in search mechanism in which the
> program will guess that the user is looking for these key words in the
> database.
> so far i came up with this but the search ain't smart, i have to write the
> full key word in order to retrieve specific information.
> from pysqlite2 import dbapi2 as sqlite3
> connection = sqlite3.connect('Photos.db')
> memoryConnection = sqlite3.connect(':memory:')
> cursor = connection.cursor()
> prompt = 'Enter your search query?\n'
> keyword = raw_input(prompt)
> if cursor.execute('SELECT * FROM photos WHERE Tag LIKE ?',[keyword]):
> print cursor.fetchall()
> else:
> cursor.execute('SELECT * FROM photos WHERE Date LIKE ?', [keyword])
> print cursor.fetchall()
> Any ideas and
> thanks in advance
> Reply

thank you man, it worked perfectly but one more thing;

when i print rows it retrieves the whole rows of info which i don't need, i
need just to retrieve the name of the photo. 
so how am i gonna do that?
View this message in context:
Sent from the Python - python-list mailing list archive at

More information about the Python-list mailing list