- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
MySQL query to display the first alphabet from strings in a separate column
To fetch the first alphabet from the strings, use LEFT(). This method allows you to return characters from the left of the string.
Let us first see an example and create a table −
mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(100) ); Query OK, 0 rows affected (1.03 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable(FirstName) values('John'); Query OK, 1 row affected (0.11 sec) mysql> insert into DemoTable(FirstName) values('Adam'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(FirstName) values('Jace'); Query OK, 1 row affected (0.16 sec) mysql> insert into DemoTable(FirstName) values('Chris'); Query OK, 1 row affected (0.10 sec) mysql> insert into DemoTable(FirstName) values('Bob'); Query OK, 1 row affected (0.12 sec) mysql> insert into DemoTable(FirstName) values('Carol'); Query OK, 1 row affected (0.11 sec)
Display all records from the table using select statement −
mysql> select *from DemoTable;
This will produce the following output −
+----+-----------+ | Id | FirstName | +----+-----------+ | 1 | John | | 2 | Adam | | 3 | Jace | | 4 | Chris | | 5 | Bob | | 6 | Carol | +----+-----------+ 6 rows in set (0.00 sec)
Following is the query to display the first alphabet from the column with string values. The result is displayed in a new column −
mysql> select Id,FirstName,upper(left(FirstName,1)) AS FirstLetter from DemoTable order by FirstName;
This will produce the following output −
+----+-----------+-------------+ | Id | FirstName | FirstLetter | +----+-----------+-------------+ | 2 | Adam | A | | 5 | Bob | B | | 6 | Carol | C | | 4 | Chris | C | | 3 | Jace | J | | 1 | John | J | +----+-----------+-------------+ 6 rows in set (0.03 sec)
- Related Articles
- MySQL query to count the duplicate ID values and display the result in a separate column
- MySQL query to match any of the two strings from column values
- MySQL query to get first two highest column values from a table?
- Display the sum of positive and negative values from a column in separate columns with MySQL
- Concatenate the column values with separate text in MySQL and display in a single column
- A single MySQL query to combine strings from many rows into a single row and display the corresponding User Id sum in another column?
- MySQL query to display columns name first name, last name as full name in a single column?
- MySQL query to display the count of distinct records from a column with duplicate records
- MySQL query to display ASC order in number column?
- Count duplicate ids and display the result in a separate column with MySQL
- Get the minimum and maximum value from a VARCHAR column and display the result in separate MySQL columns?
- MySQL query to separate and select string values (with hyphen) from one column to different columns
- MySQL query to display only the column values with corresponding column having whitespace
- Ignore NULL values from separate tables in a single MySQL query and display count of NOT NULL records
- MySQL query to group by names and display the count in a new column

Advertisements