I can’t get the closest matches right here…How can i implement difflib right here in a right order?

When i am typing “rainn”, i want to get results for “rain”.Here’s what i’ve tried – but there is no success import mysql.connector from difflib import get_close_matches con = mysql.connector.connect( user = <user>, password = <password>, host = <host>, database = <db> ) cursor = con.cursor() word = input(‘Enter a word: ‘) query = cursor.execute(‘SELECT…

Details

SQL Joined Tables – Multiple rows on joined table per ‘on’ matched field merged into one row?

I have two tables I am pulling data from. Here is a minimal recreation of what I have: Select Jobs.Job_Number, Jobs.Total_Amount, Job_Charges.Charge_Code, Job_Charges.Charge_Amount From DB.Jobs Inner Join DB.Job_Charges On Jobs.Job_Number = Job_Charges.Job_Number; So, what happens is that I end up getting a row for each different Charge_Code and Charge_Amount per Job_Number. Everything else on the…

Details