1
def SupplierLookup(Name):
  cursor = conn.cursor()

  SQL = '''SELECT CompanyName, ContactName, Phone
         FROM Supplier
         WHERE CompanyName = ?'''
  for row in cursor.execute(SQL, (Name,)).fetchall():
      print('Supplier: ' + row[0] + ' ContactPerson: ' + row[1] + ' Phone: ' + row[2])

How can i do it so if you type 'Exotic' in the parameter it will display the full word which is 'Exotic Liquid' Ive tried to use LIKE operation but it keeps failing

0 Answers0