Member Avatar for pynehalem 
To All Pythonist..

I have small SQLITE db.. for User Table

'SELECT loginUser from User';
sql = cursor.fetchall()
listSQL = sql[:]

for x in listSQL:
     print x   

     listSQL SELECT Data Produce:
        (u'user1',)
        (u'user2',)
        (u'user3',)

I want to match the list of user with a string input:

example if the value of the current user = ('user1') it should match on
the registered user in the current table.
  • 2 Contributors
  • 1 Reply
  • 321 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by woooee
Member Avatar for woooee

Use "SELECT" and "WHERE" to only return record(s) that match from the SQLite database See "Named Placeholders"

Edited by woooee
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.