摘要：
SELECTa.user_name,a.avatar,a.nicheng,a.user_rank,b.rank_name,b.rank_imgFROMecs_usersa,ecs_user_rankbWHEREuser_idin(14495)anda.rank_points˃=b.min_pointsanda.rank_points˂=b.max_points;updateecs_usersa,e
SELECT a.user_name,a.avatar,a.nicheng,a.user_rank,b.rank_name,b.rank_img FROM ecs_users a , ecs_user_rank b
WHERE user_id in(14495) and a.rank_points >= b.min_points and a.rank_points <= b.max_points ;
update ecs_users a,ecs_user_rank b
set a.user_rank =b.rank_id
WHERE user_id in(14495) and a.rank_points >= b.min_points and a.rank_points <= b.max_points ;