<div>
not to provide a solution at this stage, but is that possible to change your table design? Personally thought is that by putting all the relevant ids into a simple column is really a bad design.<br />
<br />
Do you think can create a separate table to hold the ids instead?
</div>


<div>
hi<br />
can you elaborate on that idea? maybe example?
</div>


SnapShot2.png

SnapShot1.png

<div>
<div class="content wysiwyg-content">
hi<br />
i have a table quotes that have a field quote_category which hold categories ids. meaning, this quote might belong to several categories.<br />
i attach an image of the table.<br />
for example: how can i select only quotes that the id 3 is in the quote_category array?<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/03_w10/1084473/Screenshot--11-.png" target="_blank" title="the database (181 KB)"><img alt="the database" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2016/03_w10/800_1084473/Screenshot--11-.png" /></a>
</div>
</div>


Screenshot--11-.png

hi
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?


sqlite select when values are stored in an array

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.