重新求教，mysql查询语句问题，上次表达的不清楚

[tulao7]

感谢各位能指点一二

[糖炒唐朝栗子]

SELECT mingci,bili FROM like2016 WHERE fenshu = (SELECT ROUND(zf) FROM users WHERE id = 1070) 或者用round（）取整函数

[糖炒唐朝栗子]

SELECT mingci,bili FROM like2016 WHERE fenshu = (SELECT SUBSTRING_INDEX(zf,'.',1) FROM users WHERE id = 1070)

[tulao7]

引用 2 楼 u012066228 的回复:

SELECT mingci,bili FROM like2016 WHERE fenshu = (SELECT ROUND(zf) FROM users WHERE id = 1070) 或者用round（）取整函数

我试试，谢谢老大