Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select word, hex(word) from oldword where word = 'hua';
- +--------+--------------+
- | word | hex(word) |
- +--------+--------------+
- | hũa | 6875CC8361 |
- | huã | 6875C3A3 |
- | hua | 687561 |
- | hũã | 6875CC83C3A3 |
- +--------+--------------+
- 4 rows in set (0,04 sec)
- mysql> select word, hex(word) from oldword where word like 'hua';
- +-------+------------+
- | word | hex(word) |
- +-------+------------+
- | huã | 6875C3A3 |
- | hua | 687561 |
- +-------+------------+
- 2 rows in set (0,04 sec)
- mysql> select word, hex(word) from oldword where word like 'hua%';
- +----------+------------------+
- | word | hex(word) |
- +----------+------------------+
- | huamanal | 6875616D616E616C |
- | huã | 6875C3A3 |
- | hua | 687561 |
- +----------+------------------+
- 3 rows in set (0,07 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement