56,678
社区成员
发帖
与我相关
我的任务
分享
SELECT
m.*, mp.mid,
mp.zhiwu,
mp.xueke,
mp.danwei,
mp.uname,
mp.mobile,
mp.place,
mp.city,
mp.county
FROM
`cms_member` AS m
LEFT JOIN `cms_member_person` AS mp ON m.mid = mp.mid
WHERE
-- locate('2012', m.userid) > 0
-- MATCH (m.userid) AGAINST ('好好分数');
m.userid in ('小')
ORDER BY
m.logintime DESC