explode() right on Mysql

Question

I have a column called relacionados on the table produtos and there are some ID’s of some table items produtos. I needed to make a explode() or something like that on the table produtos and selects all products with the ID’s that are in this table relacionados. Would there be any possibility ? The Ids are separated by , (commas).

Tabela = produtos
Coluna = relacionados

But I don’t need to return how many ID’s I have. What I need is to return as several SELECTS with the ID’s in the column relacionados. For example, in the column relacionados I have so: 2,3,5,10 so I had to do something like this:

SELECT * FROM produtos WHERE id = 2
SELECT * FROM produtos WHERE id = 3
SELECT * FROM produtos WHERE id = 5
SELECT * FROM produtos WHERE id = 10

Answer 1

I’m waiting for the community to decide to see if it’s a duplicate of what @rray recommended.

If the values are separated by a comma and you want to find one of them:

SELECT * WHERE FIND_IN_SET( 'b','a,b,c,d');

In your case it can be used like this:

SELECT * WHERE FIND_IN_SET( 'b', valores );

If they are separated by another character, you have a gambit a technical repair:

SELECT * WHERE FIND_IN_SET( 'b', REPLACE( coluna, '|', ',' ) );

If the need is different, edit the question with the relevant details, which update the answer.