Question

mysql中如何取一个表中某个字段最后的值！ 如，取a表b字段中c字符对应的id

Answer 1

select id from a where b like '%c%'

Answer 2

select top 1 id from a order by desc b