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?
> is there a way to sort the results of a ".. LIKE" query by hits?
i'm sorry i have
1. misunderstood the effect of LIKE
2. posted a question easy to get wrong
so, what i need to know is:
how can i sort the results of "SELECT * FROM foo WHERE bar LIKE
'%searchterm%'" or a similar search query by
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
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?
--
Sent through GMX FreeMail - http://www.gmx.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional comma
