MariaDB select record for every find_in_set values

Asked May 25 '19 at 12:36

Active May 25 '19 at 13:25

Viewed 220 times

I'm pretty sure there are already topics on this subject. I just can't find them. Sorry...

I want to select rows from a table where column = 1 or 2, or 3, or 3.

I need to use FIND_IN_SET because I don't know those numbers.

What I have now is (the numbers are an example):

SELECT
    *
FROM
    my_table
WHERE
    FIND_IN_SET(my_column, '1,2,3,3')

The query, sure, returns 3 rows.

I need 4, cause I have 4 numbers...

edited May 25 '19 at 13:25

asked May 25 '19 at 12:36

Andrei

'I need to use FIND_IN_SET' - I doubt it AND I don't really understand what you are asking. Are you saying if a number appears twice in the set that you should get 2 rows, if a number appears in the set three times you should get 3 rows (etc)? – P.Salmon May 25 '19 at 12:46
Yes. That's exactly what I want. – Andrei May 25 '19 at 12:47
What version of MySQL are you using? – Nick May 25 '19 at 12:52
Oh.... I'm using MariaDB 10.3.12... I will edit the keywords right away... – Andrei May 25 '19 at 12:55
How are you generating the query? Is the string `'1,2,3,3'` a value from another table? or is it coming from your application? – Nick May 25 '19 at 12:57
Is coming from my app (with php). – Andrei May 25 '19 at 12:58
Are there always 4 numbers? If not, what is the maximum? – Nick May 25 '19 at 13:30
I don't know the maximum... – Andrei May 25 '19 at 13:36
you would have to go deliverd table a.k.a subquery ... `SELECT * FROM (SELECT 1 AS id UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 3 ) AS selections INNER JOIN your_table ON selections.id = your_table.my_column ORDER BY selections.id ASC` .. – Raymond Nijland May 26 '19 at 14:42
See also `my_col IN (1,2,3,3)` – Rick James May 28 '19 at 04:44

0 Answers0