Searching/Matching List like SQL

RamaJin · 08-05-2011, 07:14 AM

Hi and Good Day,

I would like to ask if I can search a list with the same concept like "select blah from bled like '%search%'". I have a table of words and I populate it to a list and loop from there instead of query every word back and forth within the table

ex.

Code:

l = ['Johns','Luke John Doe','DoeJanice']
search = 'John'
if i do a:
if search in l: = will result to false

is there a way to match list in a like format?

Samhain13 · 08-12-2011, 03:14 PM

Like this?

Code:

l = ['Johns','Luke John Doe','DoeJanice']
search = 'John'
# Use list comprehension to generate a list of results.
results = [x for x in l if search in x]

Result:

Code:

['Johns', 'Luke John Doe']