select first character of string mysql

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

Search
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
source
similar questions
sql first charactermysql column start with stringhow to fetch first 5 characters in sqlmysql get first 2 characters of stringmysql query first charactersql only five first rowmysql select where starts withselect first and last row mysqlget first 3 letters in sqlhow to get first 10 records of a table in mysqlquery only first letter stringmysql first day of monthget first 3 letters name in sqlfirst letter capital in mysql querymysql remove first and last character from stringhow to select first row of database sqlmysql first day of yearmysql search like but first exact matchmysql get character setget first n letter of department name in sql
queries leading to this page
mysql first charhow to select first letter of a string in mysqlget first character mysqlselect first character of string mysql