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
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?