Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID | username | p_title | approval | Ranking
- username | p_title | approval
- ash | aaa | yes
- bill | bbb | no
- username | ranking
- ash | 1
- bill | 0
- SELECT the_table UPDATE DISTINCT username
- SET ranking = ranking+1
- WHERE approval = 'yes'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement