search

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
https://dataset.readthedocs.org/
MIT License
4.76k stars 297 forks source link

table.find() substring? #399

Closed void4 closed 2 years ago

void4 commented 2 years ago

results = table.find(mycolumn={'???': "bc"})

Is there a filter that matches if "bc" is a substring of the value in cell mycolumn, say mycolumn could be "abcd" or "abc"?

Edit: Ah, I suppose

results = table.find(mycolumn={'like': "%bc%"})

works!