Re: search for person by comparing his data with data in mysql
| From: | Jochem Maas | Date: | Sat, 20 Dec 2008 12:01:56 +0000 |
| Subject: | Re: search for person by comparing his data with data in mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-284882@lists.php.net to get a copy of this message | ||
ceo@l-i-e.com schreef:
> select
> first_name like '%$first_name%'
> + 3 * last_name like '%$last_name%'
> + 7 * email = '$email'
> as score,
that works?? I guess the expressions (e.g. email = '$email')
evaluate to bools and are auto-cast to ints.
Im guess there needs to be some parenthesis in there somewhere, no?
anyway nice snippet :-)
> first_name, last_name, email, person_id
> from person
> .
> .
> .
> order by score desc
> limit 10
>
>