摘要:
SELECT * FROMxxx AS t WHERE 1 = 1 AND t.id IN ( select id FROM ( SELECT MAX( t.id ) id FROM xxx AS t WHERE 1 = 1 GROUP BY t.id_number, t.`class` ORDER 阅读全文
摘要:
二、find_in_set为了解决like存在的问题,还可以使用mysql提供的find_in_set(str, strlist),sql可以这样写: select * from user where find_in_set('1', hobby_ids);这样mysql就会把hobby_ids的值 阅读全文