View Single Post
Old 21-08-2005, 00:49   #11
Paddy1
cf.addict
 
Join Date: Jul 2004
Posts: 352
Paddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond reputePaddy1 has a reputation beyond repute
Re: A little SQL help (possibly)

Store the individual words rather than the sentence. e.g.


My Table
-----------
SentenceId
WordNo
Word

Data
SentenceId WordNo Word
1 1 This
1 2 is
1 3 my
1 4 sentence

Then

Select Word
From my_table
Where SentenceId = 1
Order By WordNo
Paddy1 is offline   Reply With Quote