1mysql> SELECT pub_name, LEFT(pub_name, 5)
2 -> FROM publisher;
3+------------------------------+-------------------+
4| pub_name | LEFT(pub_name, 5) |
5+------------------------------+-------------------+
6| Jex Max Publication | Jex M |
7| BPP Publication | BPP P |
8| New Harrold Publication | New H |
9| Ultra Press Inc. | Ultra |
10| Mountain Publication | Mount |
11| Summer Night Publication | Summe |
12| Pieterson Grp. of Publishers | Piete |
13| Novel Publisher Ltd. | Novel |
14+------------------------------+-------------------+
158 rows in set (0.00 sec)
16