python sqlite仅比较字符串的前16个字符，在搜索表时忽略rest

import sqlite3

# 连接到 SQLite 数据库（如果不存在则创建）
conn = sqlite3.connect('example.db')
cursor = conn.cursor()

# 创建示例表
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    username TEXT NOT NULL
)
''')

# 插入一些示例数据
cursor.execute("INSERT INTO users (username) VALUES ('user1234567890')")
cursor.execute("INSERT INTO users (username) VALUES ('userabcdef')")
cursor.execute("INSERT INTO users (username) VALUES ('otheruser')")

# 提交更改
conn.commit()

# 搜索前 16 个字符为 "user" 的记录
search_term = 'user'
cursor.execute(f"SELECT * FROM users WHERE username LIKE '{search_term}%'")

# 获取并打印结果
results = cursor.fetchall()
for row in results:
    print(row)

# 关闭连接
conn.close()