What function ??


what function can i use for this :

i want to make a query where i search a part of a string


i want a query who search the string “el” in Hello


hi poussing,

one possibliliy is

     salutation ~="*el*"

but be aware that this may turn out to be an expensive functionality. if you plan to do this regularly on a certain node, work with the word fraction index.

hope this helps,
andreas f.