Quote:
Originally Posted by ownedbycats
#kobocoll is taglike so I'll try that other one too
|
If #kobocoll is tags-like then '==' won't do anything good if there is more than one value in the list.
The 'in' comparison operator will work on tags-like columns as long as the searched value cannot appear more than once. For example, consider the expression
Code:
if 'history' in tags then
It will match 'history', 'military history', 'ancient history' etc.
The 'in' operator is faster than list_contains(), so it is worth using as long as there aren't multiple super-strings of the search expression.