Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # DELETE ROWS WHERE priority > 26
- DELETE FROM tactics WHERE priority > 26;
- # CONVERT numbers TO letters
- UPDATE tactics SET priority = CHAR((96 + CONVERT(priority, UNSIGNED)) USING ASCII);
- # fix ROWS that had 0 IN the FIELD, setting it TO empty
- UPDATE tactics SET priority = '' WHERE priority = '`';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement