import sqlite3 print("") # screener TEXT, exchange TEXT, symbol TEXT, desc TEXT conn = sqlite3.connect('/home/hoogca/trading/tv.db') c = conn.cursor() #c.execute("SELECT * FROM tv WHERE screener='netherlands' AND desc LIKE '% ETF %' ORDER BY symbol ASC") c.execute("SELECT * FROM tv WHERE desc LIKE '% Dutch %' ORDER BY symbol ASC") SearchQuotes = c.fetchall() conn.close() #print(SearchQuotes) for row in SearchQuotes: screener=row[0] exchange=row[1] symbol=row[2] desc=row[3] print(f"{screener} | {exchange} | {symbol} | {desc} \n
")