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_/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php