What function ??

, ,
1

Hi

what function can i use for this :

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

example:

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


Thanks

2

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.