Re: indexing table by word not by column

Well if It would be indexed by word it wont need any 'like'

the index tabled of table named AAA would contain something like word: row:
abc 1,2,3
def 2,3,9,4

which mean that row 9 looks something like: "bla bla def bla" (word def in line 9 in AAA) and row 2 would be: "booo def bla bla abc" (words abc and def in row 2 in AAA)

then searching on table AAA would only be

select abc from index_table where word="abc"

is there something like that?

--
Posted via CNET Help.com
http://www.help.com/