sqlite WHERE query

Question

I am trying to query SQLite in flask using the following

cur = g.db.execute('select * from movies where category = action')

but I receive the following error

OperationalError: no such column: action

How can I execute the query?

oz123 · Accepted Answer · 2015-10-26 16:53:35Z

3

You should quote action to make it a string and not a column.

 cur = g.db.execute('select * from movies where category = "action"')

oz123

29k30 gold badges133 silver badges196 bronze badges

answered Oct 26, 2015 at 16:52

emre.

1,29611 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1