How to get Max date with selected row id in Mysql

Question

I have a scenario in which i want to get Maximum Date but not from Whole Table Just from Selected id but i failed.

Here is my table

I run This Query For get my selected id

SELECT * FROM `tbl_methodology` WHERE FIND_IN_SET(6, `col_select_corporate`)

and i got that result

From that result I want to get that record which have maximum Date

I try that query but it not working for me

SELECT * FROM `tbl_methodology` WHERE  id IN (1,5,7) AND `col_date` = (
    SELECT MAX(`col_date`)
    FROM `tbl_methodology`)

Can anyone help me??

`SELECT MAX(col_date) FROM tbl_methodology WHERE id IN (1,5,7) FROM tbl_methodology)` — Perry, Jul 27 '16 at 09:57
You can use `order by` like as `SELECT * FROM tbl_methodology WHERE FIND_IN_SET(6, col_select_corporate) order by date desc limit 1` — Narendrasingh Sisodia, Jul 27 '16 at 09:59

score 1 · Accepted Answer · answered Jul 27 '16 at 09:59

1

Add the where clause twice and you should get the result you expected:

SELECT * FROM `tbl_methodology` WHERE  id IN (1,5,7) AND `col_date` = (
    SELECT MAX(`col_date`)
    FROM `tbl_methodology` WHERE  id IN (1,5,7))

And as i commented: it is very bad db design, to save values as CSV

answered Jul 27 '16 at 09:59

Jens

i am new in Programming. That is my learning stage. Thanks for your suggestion. Thank you so much :) – sunny Jul 27 '16 at 10:01

1 Answers1