In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] wrote:
> "SELECT bar FROM foo WHERE bar LIKE '%foo%'" should return something like
> the order
>
> bar
> ---
> 'foo' (exact match)
> 'the foo is a foo is a foo' (3 matches)
> 'have you seen the foo?' (1 match)
What DBMS?
if you mean something like
"SELECT * FROM THETABLE WHERE subject LIKE '%foo%' ORDER BY hitcount ASC"
yes it is ... ;-)
>Hi there. Is there a way to sort results of a '.. WHERE subject LIKE %foo%'
>query by HITS in order to use it for a search engine?
--
PHP Database Mailing List (http://www.ph
Need to see the entire Select statement.
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 4:19 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sql: LIKE
Hi there. Is there a way to sort results of a '.. WHERE