Prev: Fastest way to move lots of data between databases on same server.
Next: Calling a user-defined function?
From: mandy on 11 Jun 2010 03:05
Hi,

I wanted to design any word order query for one of my assignment. I have a
table containing around 10 million records, containing only 2 columns for
example. [id] and [text] as follows. [id] is identity.
[id] | [text]
-------------
1 | foo boo xoo
2 | foo xoo boo
3 | candy
4 | abc xy
5 | foo boo xoo
6 | xy abc
7 | mandy candy
8 | sss iii s
9 | s iii sss
10 | micro sosoft

I want to fire a query on this table so that I would get records having any
word order match. I am expecting output as follows

[id] | [text]
-------------
1 | foo boo xoo
2 | foo xoo boo
5 | foo boo xoo
4 | abc xy
6 | xy abc
8 | sss iii s
9 | s iii sss

I am playing with an option of FREETEXT from Free Text Search of SQL but no
luck.

Anyone has any pointer on this? Please let me know...

 | 
Pages: 1
Prev: Fastest way to move lots of data between databases on same server.
Next: Calling a user-defined function?