Re: search for person by comparing his data with data in mysql
| From: | ceo at l-i-e dot com | Date: | Fri, 19 Dec 2008 20:07:49 +0000 |
| Subject: | Re: search for person by comparing his data with data in mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-284859@lists.php.net to get a copy of this message | ||
select
first_name like '%$first_name%'
+ 3 * last_name like '%$last_name%'
+ 7 * email = '$email'
as score,
first_name, last_name, email, person_id
from person
.
.
.
order by score desc
limit 10