Rajesh Kumar Mallah wrote:
On Thursday 17 Jul 2003 8:21 am, Terence Kearns wrote:
select id from tablename where message like '%sql%';
If there any way to determine exactly how many times 'sql' is matched in
that search in each particular row, and then sort by the most matches,
or am I going to
On Thursday 17 Jul 2003 8:21 am, Terence Kearns wrote:
> >>select id from tablename where message like '%sql%';
> >>
> >>If there any way to determine exactly how many times 'sql' is matched in
> >>that search in each particular row, and then sort by the most matches,
> >>or am I going to have t
select id from tablename where message like '%sql%';
If there any way to determine exactly how many times 'sql' is matched in
that search in each particular row, and then sort by the most matches,
or am I going to have to write a script to do the sorting for me?
You could probably write a functio
Have you seen contrib/tsearch ?
http://www.sai.msu.su/~megera/postgres/gist/tsearch/
Oleg
On Wed, 16 Jul 2003, jtx wrote:
> I'm trying to build a really basic search engine for a site I'm using -
> say I'm going to simplify this as much as I can.
>
> Say I have a table with 2 columns: id, messag
I'm trying to build a really basic search engine for a site I'm using -
say I'm going to simplify this as much as I can.
Say I have a table with 2 columns: id, message
Person wants to search for the term 'sql'. So, I'd do a simple search
like:
select id from tablename where message like '%sql%'
