Hello,
I try to solve my
712936 with Wildcards
The search-string looks like this:
+({searchBla_1}) AND ({searchFoo_123} OR {searchFoo_124} OR {searchFoo_125})+
To reduce the number of chars, I want to replace the word *"search"* with *'%'*, or *'s%'* if it would be better for perfomance.
The new string:
+({%Bla_1}) AND ({%Foo_123} OR {%Foo_124} OR {%Foo_125})+
doesn't work. Now I read that curly braces {} around things tells Oracle to ignore the special meanings of certain characters and treat them as just characters.
Ok, but +(searchBla_1) AND (searchFoo_123 OR searchFoo_124 OR searchFoo_125)+ doesn't work, too!
Can someone tell me where here's the problem?
The attribute is CLOB-Type with full of text like:
+(CLOB) searchFooBar_123 searchFooTop_123 searchFooFlop_125 searchFooDoo_126 searchFooPa_127 searchFooLa_128 searchFooKil_129 searchFooZill_122 searchFoo_000+
I'm searching with Oracle Text:
WHERE contains(Index, :mySearchString, 1) > 0