Postgres Pro
Downloads
Home   >   mailing lists

Search Engine with PHP - Mailing list pgsql-sql

From Mike Field
Subject Search Engine with PHP
Date
Msg-id 00c101bf0434$8c44e8c0$0300a8c0@mike
Whole thread Raw
List pgsql-sql
Tree view
 
    Hi all-
 
I'm making an internal search engine with PHP.
So far, the user enters keywords and the database is searched with:
 
SELECT ... WHERE lower(fieldname) LIKE lower(keyword1) AND lower(fieldname) LIKE lower(keyword2)...
 
and this works great.  Although, now I want the answers diplayed in order of best match (not sorted just by a fieldname).  How do I do this?  Do I need to totally restructure the search engine?  Can I do it with a count( ) function?  If so, how? 
 
Any help would be great.
Thanks,
Mike
 
 

pgsql-sql by date:

Previous
From: "Stephen Horton"
Date:
Subject: please remove me from the list
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Subselect performance