RE: Number of Word Matches

2001-06-18 Thread Chris Bolt
> Hi there, > > I'm using select queries like > > SELECT * FROM table_name WHERE col_name LIKE '%some_word%' > > to find rows that have col_name match to some_word. But I would also like > to find the number of word matches for each row so that I ca

Number of Word Matches

2001-06-17 Thread pkwu330
Hi there, I'm using select queries like SELECT * FROM table_name WHERE col_name LIKE '%some_word%' to find rows that have col_name match to some_word. But I would also like to find the number of word matches for each row so that I can order these rows according to their rele