Geek asks and answers

How to organize a person search?

Let's say I have a list of people in my data warehouse. Each can have the following fields:

  • last name (*)
  • name
  • middle name
  • id (*)
  • driver license id (*)
  • another identifier (*)
  • Date of Birth
  • region
  • Place of Birth

At least one field marked with (*) must exist.

Now the user provides me with the same list of fields (and at least one field marked with (*) must be provided). I have to look for the person you provided. But not all fields need to be matched. I have to show the user somehow how confident I am in the search results. Sort of:

  • id last name ( 2 ), , (100%);
  • id last name ( , , ), , 60%;
  • .

( )

? ? .

P.S. .

+5
1

, . , , , , . , , , :

SELECT * FROM users WHERE id = `the_id` OR last_name = `the_last_name`;

, , , . GAE. , , OR AND.

+1

More articles:


All Articles