MySQL using function IN with variable

Question

I have problem querying table with variable in IN function.

SELECT 
    s.date,
    (SELECT
         GROUP_CONCAT(value) 
         FROM value 
         WHERE id_value 
         IN(s.ref_values)
    ) AS vals
FROM stats s
ORDER BY s.date DESC
LIMIT 1

Where s.ref_values is '12,22,54,15'. I get only one return for first number (12).

When I insert that value directly in IN(12,22,54,15) it finds all 4.

So, there must be problem with using variable in IN. What am I doing wrong?

Anudeep Bulla · Accepted Answer · 2013-11-05 09:51:26Z

1

Rewrite your query to

SELECT 
s.date,
(SELECT
     GROUP_CONCAT(value) 
     FROM value 
     WHERE id_value 
     IN(SELECT ref_values FROM stats)
) 
AS vals
FROM stats s
ORDER BY s.date DESC
LIMIT 1

and see if that helps.

You should ideally be passing a result set as a parameter to IN

answered Nov 5, 2013 at 9:51

Anudeep Bulla

8,5974 gold badges24 silver badges30 bronze badges

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

2 Comments

misanov Over a year ago

Same result :-(. I can get extra (first) query for ref_values, but it is complicated when I want to have it for each row.

Anudeep Bulla Over a year ago

Still facing the same problem?

Collectives™ on Stack Overflow

MySQL using function IN with variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related