Avatar of derrida

asked on 

sqlite select when values are stored in an array

i have a table quotes that have a field quote_category which hold categories ids. meaning, this quote might belong to several categories.
i attach an image of the table.
for example: how can i select only quotes that the id 3 is in the quote_category array?
the database

Avatar of undefined
Last Comment
Ryan Chong

8/22/2022 - Mon