i want to search for "any phrase here*" where i want it to match the exact same phrase and followed by anything. but the problem is that when using the following syntax: contains(myTbl,'"my phrase here*"') i will get results like "my123 phrases here" so the wildcard will be applied to the consecutive words and not the last word.
How can i search for an exact phrase followed by anything?
ps: i cant omit the wildcard becoz the last word is not exact
so treating the space as any other character and not as a seperator in the search_expression may be a solution but how to do it
i wanted to make my search as fast as possible but it seems that full-text search is a wrong decision in my case becoz am searching in a column containing file Path which contains back slashes and back slashes r considered as white spaces while indexing so my search wont be accurate anyway.
becoz the following 2 path will be the same if using fts: