Mysql.connector.errors.ProgrammingError: 1054 (42S22): Unknown column ' ' in 'where clause'. How to decide?

Question

MySQL

the function accepts an incoming message:

def check_answer(message):

    db_work = mySQL()

    a = db_work.check_answers(message)
    print(a)
    db_work.close()

send a query to the database if the table has the following value:

def check_answers(self, text):
        self.cursor.execute("SELECT * FROM answers WHERE text = " + str(text))
        data = self.cursor.fetchone()
        return data

it responds normally to the first 2 numeric requests. on the third aggro.
you need to make foolproof:
if the user drives in something random, and not the values ​​\u200b\u200bthat are in the database,
data should simply return 0, None, False. (whatever)
But it crashes and writes that the column was not found when it is not a column but a value in the column

Answer 1

fix it

self.cursor.execute("SELECT * FROM answers WHERE text = " + str(text))

on the

self.cursor.execute("SELECT * FROM answers WHERE text = '" + str(text) + "'")