Techiio-author
Started by David HarrisonOct 2, 2021

Open
Name matching in sql

1 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 1 VIEWES SHARE

How can I implement name matching function in sql? I searched online, but I found them using T-Sql for name matching. I want to implement name matching in sql, so that I pass two strings to that function and get matching score in return.

1 Replies

Techiio-commentatorJhone Buttler replied 3 months ago0 likes0 dislikes

You must fix the names in the database. Databases are meant for exact matches, not "looks mostly like". The most simple fix is probably to export the table in a CSV format, load it in Excel (two columns: Primary key and city name), and then use a spell checker to fix the names.

You must be Logged in to reply
Trending Technologies
15
Software91
DevOps48
Frontend Development24
Backend Development20
Server Administration17
Linux Administration28
Data Center24
Sentry24
Terraform23
Ansible83
Docker70
Penetration Testing16
Kubernetes21
NGINX20
JenkinsX17
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance