在python中与pandas一起实现sqlite sort by函数和select函数

我正在写一个程序来搜索数据库。我的表包含id,title,date,content。我只需要日期和内容作为输出。输出必须根据“id”进行排序。但我不希望输出id。我该如何实现? 我试图在选择id和内容之前对数据进行排序,不幸的是,它没有给出所需的结果。

import os
import pandas as pd

conn = sqlite3.connect('insight.db')
c = conn.cursor()

def search_keyword(term):
    c.execute("SELECT * FROM GkData ORDER BY Id DESC")
    print(pd.read_sql_query("SELECT date, content FROM GkData WHERE {} LIKE '%{}%'".format('content', term), conn))
    c.execute("SELECT content FROM GkData WHERE {} LIKE '%{}%'".format('content', term))
    data = c.fetchall()
    for idx, row in enumerate(data):
        new_data = str(row).replace("',)", "  ").replace("('", " ")
        print('[ ' + str(idx) + ' ] =====> ' + new_data)

while True:
    search = input("Search term: ")
    search_keyword(str(search))

conn.close()

Output image of the program

Image of Table