How to display value in sqlite3?

Question

Python

how can i find all rows in db where user_id = msg.chat.id.

Code below

user_id = msg.chat.id.
#тут коннект к бд
cur.execute("SELECT balance FROM orders WHERE user_id={user_id};")#пробовал так,дает ошибку sqlite3.OperationalError: unrecognized token: "{

I also wanted to ask, will it display the number simply or the number and all sorts of brackets?
thanks in advance

Answer 1

Once again I will give you a link to the documentation , where there is even an example.