mysql : Return rows which matches the value in array

Question

Updated Question : I have the below data ,When i query for column consists "999" , I need to get last row details. Can you please guide me on this.

find_in_set not working for the array data like below. find_in_set("999" , column)

Table :

How do i get the last column when i query for column = 999 Dont want to use LIKE here , because I need to match for exact values

Have you tried removing the the square braces [ and ] from the column before you do find_in_set("999", column)? — Sujith
– Sujith, Commented Aug 4, 2017 at 1:22
i dont want to modify the data in database. do you mean after fetching the data to remove braces? — dishanm
– dishanm, Commented Aug 4, 2017 at 1:24
Yes also you need to remove " from the column values, it should be just 12345,999. This can be done in the query level , you don't need modify the data in table — Sujith
– Sujith, Commented Aug 4, 2017 at 1:29
You seemed very confused about SQL. Can you update your question to show us an exact sample of data you want to match along with which of those rows should appear in the output? — Tim Biegeleisen
– Tim Biegeleisen, Commented Aug 4, 2017 at 1:32
@dishanm find_in_set just gives you the position of the string you are searching for. My answer below is based on what you have asked. — Sujith
– Sujith, Commented Aug 4, 2017 at 1:34

Sujith · Accepted Answer · 2017-08-04 01:44:21Z

1

I have created a SQLFiddle to write and refine your query. Here is the working sample of the same:

It is just a sample, which has same data as you have in your table. Modify and play with it.

answered Aug 4, 2017 at 1:33

Sujith

1,8241 gold badge10 silver badges16 bronze badges

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

Update the Fiddle link in my answer... You can see what you want. Also please mark as answer if it was helpful to you