AES_ENCRYPTで暗号化したテーブルをORDER BYで正常に並び替える ref: https://qiita.com/Go-Noji/items/a233595832201b2ec5e9

file0.sql

CREATE TABLE IF NOT EXISTS `user` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` BLOB DEFAULT NULL,
  `savings` BLOB DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET = utf8 AUTO_INCREMENT = 1;

file1.sql

INSERT INTO `user` (`name`, `savings`)
VALUES (AES_ENCRYPT('めぐろ', 'password'), AES_ENCRYPT(100000, 'password')),
(AES_ENCRYPT('しながわ', 'password'), AES_ENCRYPT(8000000, 'password')),
(AES_ENCRYPT('しぶや', 'password'), AES_ENCRYPT(200, 'password')),
(AES_ENCRYPT('いけぶくろ', 'password'), AES_ENCRYPT(-50000, 'password')),
(AES_ENCRYPT('えびす', 'password'), AES_ENCRYPT(7005000, 'password')),
(AES_ENCRYPT('おおさき', 'password'), AES_ENCRYPT(0, 'password')),
(AES_ENCRYPT('にしにっぽり', 'password'), AES_ENCRYPT(9, 'password')),
(AES_ENCRYPT('はらじゅく', 'password'), AES_ENCRYPT(-99999999, 'password')),
(AES_ENCRYPT('ごたんだ', 'password'), AES_ENCRYPT(777777777777, 'password'));

file10.sql

SELECT `id`, AES_DECRYPT(`name`, 'password'), AES_DECRYPT(`savings`, 'password')
FROM `user`
ORDER BY AES_DECRYPT(`savings`, 'password');

file11.txt

+----+---------------------------------+------------------------------------+
| id | AES_DECRYPT(`name`, 'password') | AES_DECRYPT(`savings`, 'password') |
+----+---------------------------------+------------------------------------+
|  4 | いけぶくろ                      | -50000                             |
|  8 | はらじゅく                      | -99999999                          |
|  6 | おおさき                        | 0                                  |
|  1 | めぐろ                          | 100000                             |
|  3 | しぶや                          | 200                                |
|  5 | えびす                          | 7005000                            |
|  9 | ごたんだ                        | 777777777777                       |
|  2 | しながわ                        | 8000000                            |
|  7 | にしにっぽり                    | 9                                  |
+----+---------------------------------+------------------------------------+

file12.sql

SELECT `id`, AES_DECRYPT(`name`, 'password'), AES_DECRYPT(`savings`, 'password')
FROM `user`
ORDER BY CAST(AES_DECRYPT(`savings`, 'password') AS SIGNED);

file13.txt

+----+---------------------------------+------------------------------------+
| id | AES_DECRYPT(`name`, 'password') | AES_DECRYPT(`savings`, 'password') |
+----+---------------------------------+------------------------------------+
|  8 | はらじゅく                      | -99999999                          |
|  4 | いけぶくろ                      | -50000                             |
|  6 | おおさき                        | 0                                  |
|  7 | にしにっぽり                    | 9                                  |
|  3 | しぶや                          | 200                                |
|  1 | めぐろ                          | 100000                             |
|  5 | えびす                          | 7005000                            |
|  2 | しながわ                        | 8000000                            |
|  9 | ごたんだ                        | 777777777777                       |
+----+---------------------------------+------------------------------------+

file2.sql

SELECT *
FROM `user`;

file3.txt

+----+------------------+------------------+
| id | name             | savings          |
+----+------------------+------------------+
|  1 | ﾗjZﾔ:,X8蕃・| 9ﾖfﾉ殉｢ﾀ$uj |
'ﾝ鋗ﾜ｣ |｡=截ｻﾁﾇ難寛襯  | ｴ^ﾜw2-ｽ
|  3 | ｨ>ｹﾋ"#p鬘~禽ｩ/ﾉ | ｸｿｽr 竓倢Hｦﾇ |
|  4 |  /妻ﾌﾄ4ｵ・ ｨeﾚﾜ | U・ﾏ{uwI・ﾙgs |
諚k7#ｭﾈﾀｺ2ﾙ｣ |0・ﾕ>ｼ | ｿ
|  6 | 僴嶸b・Vｵ|"ｹ･ﾔ | M・ｽcﾊﾊ?"･ |
|  7 | 穆wC､ｰ1J瞹*IｪLﾍ | 倭Gﾎﾁﾏ-jｴp煉 |
|  8 | 鶴｣錠ﾆo・=ｱﾘﾊ | <Kｦ嚔・⑰TLq |
|  9 | ∑･'N確aｲ・｣Т | ,0'ｱｰｮ&|d_・|
+----+------------------+------------------+

file4.sql

SELECT `id`, AES_DECRYPT(`name`, 'password'), AES_DECRYPT(`savings`, 'password')
FROM `user`;

file5.txt

+----+---------------------------------+------------------------------------+
| id | AES_DECRYPT(`name`, 'password') | AES_DECRYPT(`savings`, 'password') |
+----+---------------------------------+------------------------------------+
|  1 | めぐろ                          | 100000                             |
|  2 | しながわ                        | 8000000                            |
|  3 | しぶや                          | 200                                |
|  4 | いけぶくろ                      | -50000                             |
|  5 | えびす                          | 7005000                            |
|  6 | おおさき                        | 0                                  |
|  7 | はらじゅく                      | -99999999                          |
|  8 | ごたんだ                        | 99999999999999                     |
+----+---------------------------------+------------------------------------+

file6.sql

SELECT `id`, AES_DECRYPT(`name`, 'password'), AES_DECRYPT(`savings`, 'password')
FROM `user`
ORDER BY `name`;

file7.txt

+----+---------------------------------+------------------------------------+
| id | AES_DECRYPT(`name`, 'password') | AES_DECRYPT(`savings`, 'password') |
+----+---------------------------------+------------------------------------+
|  6 | おおさき                        | 0                                  |
|  4 | いけぶくろ                      | -50000                             |
|  2 | しながわ                        | 8000000                            |
|  5 | えびす                          | 7005000                            |
|  9 | ごたんだ                        | 777777777777                       |
|  7 | にしにっぽり                    | 9                                  |
|  3 | しぶや                          | 200                                |
|  1 | めぐろ                          | 100000                             |
|  8 | はらじゅく                      | -99999999                          |
+----+---------------------------------+------------------------------------+

file8.sql

SELECT `id`, AES_DECRYPT(`name`, 'password'), AES_DECRYPT(`savings`, 'password')
FROM `user`
ORDER BY AES_DECRYPT(`name`, 'password');

file9.txt

+----+---------------------------------+------------------------------------+
| id | AES_DECRYPT(`name`, 'password') | AES_DECRYPT(`savings`, 'password') |
+----+---------------------------------+------------------------------------+
|  4 | いけぶくろ                      | -50000                             |
|  5 | えびす                          | 7005000                            |
|  6 | おおさき                        | 0                                  |
|  9 | ごたんだ                        | 777777777777                       |
|  2 | しながわ                        | 8000000                            |
|  3 | しぶや                          | 200                                |
|  7 | にしにっぽり                    | 9                                  |
|  8 | はらじゅく                      | -99999999                          |
|  1 | めぐろ                          | 100000                             |
+----+---------------------------------+------------------------------------+