What if you want to search using FTS with AND logic using the FORMSOF(inflectional,...) inside the CONTAINS() clause???
if my search phrase is "light hearted" I can easily do an OR search using the following in my where clause:
CONTAINS(Colname,'formsof(INFLECTIONAL,light,heart ed).
but the and is far more tricky....
does anyone know how to do this without having multiple Contains statements (which greatly increases overhead)?
I know that I can use AND in a straight contains like so:
CONTANS(column, '"light" AND "hearted"') but this does not allow me to explore inflectional variations on the words...
nesting multiple FORMSOF's doesn't seem to work either like so:
contains(column,'"formsof(inflectional,light)"' AND 'formsof(inflectional,hearted)"')
anyone else found how to do this?
3  4871 
just to clarify I think 2 better search words for my ex. would have been "sport" and "award" and it's really important that I get results for Sports, Sported, Awards, and Awarded. Then I'd have any combination of the two words Inflectional variations (one from each root word) that exist in the same record returned in my resultset.
Hello garrettm,
I've been googling like crazy and it seems that I have the same question that you have. Did you ever find a solution? For me, the following formsof clause compiles but it doesn't return results:
formsof(inflectional, "surreal artist")
Although there is clearly the phrase "surreal artist" in my database. Using freetexttable, I do get it in my result set--but I like the control I have with containstable.
Hello garrettm,
I've been googling like crazy and it seems that I have the same question that you have. Did you ever find a solution? For me, the following formsof clause compiles but it doesn't return results:
formsof(inflectional, "surreal artist")
Although there is clearly the phrase "surreal artist" in my database. Using freetexttable, I do get it in my result set--but I like the control I have with containstable.
I posted the answer on WIKI in the discussion page... HERE IS THE LINK Sign in to post your reply or Sign up for a free account.
Similar topics
by: Jack |
last post by:
Hi,
I have come to point in my db design where I'm trying to figure which
is the best approach in making it generic (does this really matter?!?)
Senario - I have a table called JOBS and this...
|
by: Andrew Poulos |
last post by:
If I'm searching for an occurance of a value in a multi-dimensional
array how can I get it's index returned as an array, if found? For
example, if:
foo = new Array();
foo = , 5, , 9, 10];
...
|
by: Jean |
last post by:
Hello all,
I have the following data, that was queried and sorted to columns
PROBLEM_ID and then by STATUSDATE (ascending):
STATUS_ID STATUSDATE PROBLEM_ID
--------- ---------- ...
|
by: dan heskett |
last post by:
Hello group,
I am trying to get used to vb.net coming from a far far far away set of tools.
What i want to do is setup an object in my application that contains other
object types, that act...
|
by: Jobs |
last post by:
Download the JAVA , .NET and SQL Server interview with answers
Download the JAVA , .NET and SQL Server interview sheet and rate
yourself. This will help you judge yourself are you really worth of...
|
by: farriswheel |
last post by:
Good Day,
I am attempting get a total sum for the items selected, I keep receiving a error in my query when I try to use the where clause: "the expression is typed incorrectly"
Notice in the...
|
by: Mr. SweatyFinger |
last post by:
where have they all gone.
alt.suicide?
alt.findContol.then.slit.your.own.throat?
|
by: askmeofit |
last post by:
I'm a Phd student in statistics, and I'm writing computer code for the
simulation of stochastic differential equations.
Little background about my knowledge: I know C programming decently,
and my...
|
by: =?Utf-8?B?VGVycnk=?= |
last post by:
I am implementing an 'incremental search', where as the user types into a
textbox, a datagridview's current position is updated to match the first
record that contains what the user has typed so...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
