| From: | "Mike Field" <mike(at)fieldco(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Search Engine with PHP |
| Date: | 1999-09-21 13:23:47 |
| Message-ID: | 00c101bf0434$8c44e8c0$0300a8c0@mike |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
mike(at)fieldco(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 1999-09-21 14:15:32 | Re: [SQL] Subselect performance |
| Previous Message | Stephen Horton | 1999-09-21 13:01:29 | please remove me from the list |