Re: Efficien search queries
| From: | Marius Ursache | Date: | Fri, 19 Apr 2002 05:16:53 +0000 |
| Subject: | Re: Efficien search queries | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18667@lists.php.net to get a copy of this message | ||
hi
do you use "OR" and "AND" ?
select * from table where pasta like "%spagetti%" or pasta like
"%macaroni%"
?
eat pasta type fasta a écrit :
> I have simple db wik names, links and short (less then 1000 chars)
> descriptions. I do offer a search (with the select like %variable%
> method) but it seems to be very dumb, on single phrases it goes fine on
> combined it it very bad.
> Is there a way (link, advice) to spicy it up a bit so the user can get
> more out of it each time.
>
> Thanks in advance.
>
> R>
>
> ________________________--__-______-______________
> eat pasta
> type fasta
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
Marius Ursache (3563 || 3494)
\|/ ____ \|/
"@'/ ,. \`@"
/_| \__/ |_\
\__U_/