sql function to compare 2 strings for possible matches
$10-30 USD
Cancelado
Publicado há quase 6 anos
$10-30 USD
Pago na entrega
Need sql function to compare 2 strings of names to determine if they match. See the examples below.
The below set is a Match
Str1 Str2
John Doe John Doe
John, Doe John Doe
John Doe John, Doe
John Doe Doe John
John L Doe John Doe
Doe John John L Doe
Doe L. John John L Doe
Doe L. John John L. Doe Jr.
Doe L John John L. Doe Jr.
Doe L John John L. Doe
Doe John John Lee Doe
Doe Lee John John L Doe
Doe Lee John John Doe
John Doe Sarah Doe and John Doe
John Doe Sarah Doe & John Doe
Doe John R John R Doe
Doe John R John Ray Doe
Doe John Ray John R Doe
The below set is NOT a match
Jay Taft John Doe
Doe L John John R. Doe
Sarah R Doe John R Doe
Sarah R Doe John R Doe
HI,
I can help you with the project.
I am good at: PHP, CodeIgniter, laravel, jquery, MySQL, google map API.
Let me know when we can discuss and start working.
Looking forward to your response.
Thanks....
Hi,
I read your description carefully and I am sure I can do it in a day.
I can complete this by using regular expression.
Please contact me if you want.
Regards,