How to select a row from array in column in mysql

Question

I want to select a row from my table where the "user id" is equal to some userid, but my columns are an array. How can I select on it?

Image of MySQL Page

MySQL has no type called "array" so I don't understand the question. I do see strings with commas which is usually an indicator that the data model needs to be fixed. — Gordon Linoff
– Gordon Linoff, Commented May 4, 2019 at 11:24

Akshay Honnalli · Accepted Answer · 2019-05-04 06:33:52Z

3

select * from table_name where FIND_IN_SET(@user_id,user_id) > 0

answered May 4, 2019 at 6:33

Akshay Honnalli

1364 bronze badges

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

Comments

Atul Mathew · Accepted Answer · 2019-05-04 06:19:33Z

0

are you expecting something like this

select * from table_name where userid=@userid

answered May 4, 2019 at 6:19

Atul Mathew

4553 silver badges17 bronze badges

i have array in column and i want to select from column but i cant select from array in sql

Yabaz Thampi · Accepted Answer · 2019-05-04 06:24:57Z

0

Try this Query..

select * from table where CONCAT(',', userid, ',') like '%,@yourid,%'

answered May 4, 2019 at 6:24

Yabaz Thampi

8211 bronze badges

SAVe · Accepted Answer · 2019-05-04 06:32:55Z

0

Try this mysql

select * from table_name where FIND_IN_SET('%@userid%',userid);

answered May 4, 2019 at 6:32

SAVe

8126 silver badges22 bronze badges