How to get and send all the strings in the Telegram bot that include one of the variables in the database?

Question

Python

I need to extract the name from a string, for example: "s Miha", and use it to find all the lines in the database where this name is, and accordingly send it all in a message to the user.

I tried to write this code:

@bot.message_handler(func=lambda m: True)
def show_oper(message):
    if message.text.startswith("s"):
        mess_oper_name = message.text.split()[1]
        with sqlite3.connect('database.db') as db:
            cursor = db.cursor()
            result = cursor.execute('SELECT * FROM opers_list WHERE oper = ?', [mess_oper_name]).fetchall()
        bot.reply_to(message, '\n'.join(result))

however errors in the console get out and nothing is sent.

Is there any other way to implement this?

Answer 1

result contains a nested list with all the data fields of the table. Something like this: [
(row1value1, row1value2, ...), (row2value1, row2value2, ...), ...
]
. ]
then you can already do '\n'.join()
If you still don't understand, here's an example from recent answers.