select first character of string mysql

Solutions on MaxInterview for select first character of string mysql by the best coders in the world

showing results for - "select first character of string mysql"
Lea
22 Jan 2016
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