MySQL String Exercises: Get the details of the employees where the length of the first name greater than or equal to 8

Last update on February 03 2026 12:43:04 (UTC/GMT +8 hours)

MySQL String: Exercise-3 with Solution

Write a MySQL query to get the details of the employees where the length of the first name greater than or equal to 8.

Sample table: employees

+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
| EMPLOYEE_ID | FIRST_NAME  | LAST_NAME   | EMAIL    | PHONE_NUMBER       | HIRE_DATE  | JOB_ID     | SALARY   | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
|         100 | Steven      | King        | SKING    | 515.123.4567       | 1987-06-17 | AD_PRES    | 24000.00 |           0.00 |          0 |   		  90 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | 1987-06-18 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | 1987-06-19 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | 1987-06-20 | IT_PROG    |  9000.00 |           0.00 |        102 |            60 |
|         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | 1987-06-21 | IT_PROG    |  6000.00 |           0.00 |        103 |            60 |
|         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | 1987-06-22 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | 1987-06-23 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | 1987-06-24 | IT_PROG    |  4200.00 |           0.00 |        103 |            60 |
|         108 | Nancy       | Greenberg   | NGREENBE | 515.124.4569       | 1987-06-25 | FI_MGR     | 12000.00 |           0.00 |        101 |           100 |
..........
|         206 | William     | Gietz       | WGIETZ   | 515.123.8181       | 1987-10-01 | AC_ACCOUNT |  8300.00 |           0.00 |        205 |           110 |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+

View the table

Output:

-- This SQL query selects all columns from the 'employees' table where the length of the first name is greater than or equal to 8.

SELECT 
    * -- Selecting all columns from the 'employees' table.
FROM 
employees -- Specifying the 'employees' table.
WHERE 
LENGTH(first_name) >= 8; -- Filtering the rows to include only those where the length of the first name is greater than or equal to 8.

Explanation:

This SQL query retrieves all columns from the 'employees' table.
The WHERE clause filters the result set to include only records where the length of the first name is greater than or equal to 8 characters.
The LENGTH() function is used to calculate the length of the first name.
Rows where the length of the first name meets the specified condition are included in the result set.

Sample Output:

 employee_id | first_name  | last_name |  email  |    phone_number    | hire_date  |   job_id   |  salary  | commission_pct | manager_id | department_id
-------------+-------------+-----------+---------+--------------------+------------+------------+----------+----------------+------------+---------------
         103 | Alexander   | Hunold    | AHUNOLD | 590.423.4567       | 2006-01-03 | IT_PROG    |  9000.00 |           0.00 |        102 |            60
         112 | Jose Manuel | Urman     | JMURMAN | 515.124.4469       | 2006-03-07 | FI_ACCOUNT |  7800.00 |           0.00 |        108 |           100
         115 | Alexander   | Khoo      | AKHOO   | 515.127.4562       | 2003-05-18 | PU_CLERK   |  3100.00 |           0.00 |        114 |            30
         153 | Christopher | Olsen     | COLSEN  | 011.44.1344.498718 | 2006-03-30 | SA_REP     |  8000.00 |           0.20 |        145 |            80
         163 | Danielle    | Greene    | DGREENE | 011.44.1346.229268 | 2007-03-19 | SA_REP     |  9500.00 |           0.15 |        147 |            80
         169 | Harrison    | Bloom     | HBLOOM  | 011.44.1343.829268 | 2006-03-23 | SA_REP     | 10000.00 |           0.20 |        148 |            80
         172 | Elizabeth   | Bates     | EBATES  | 011.44.1343.529268 | 2007-03-24 | SA_REP     |  7300.00 |           0.15 |        148 |            80
         176 | Jonathon    | Taylor    | JTAYLOR | 011.44.1644.429265 | 2006-03-24 | SA_REP     |  8600.00 |           0.20 |        149 |            80
         178 | Kimberely   | Grant     | KGRANT  | 011.44.1644.429263 | 2007-05-24 | SA_REP     |  7000.00 |           0.15 |        149 |             0
         189 | Jennifer    | Dilly     | JDILLY  | 650.505.2876       | 2005-08-13 | SH_CLERK   |  3600.00 |           0.00 |        122 |            50
         200 | Jennifer    | Whalen    | JWHALEN | 515.123.4444       | 2003-09-17 | AD_ASST    |  4400.00 |           0.00 |        101 |            10
(11 rows)

Go to:

PREV : Write a MySQL query to update the portion of the phone_number in the employees table, within the phone number the substring '124' will be replaced by '999'.
NEXT : Write a MySQL query to display leading zeros before maximum and minimum salary.

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.