w3resource

Basic SELECT statement: Check whether the column first_name of the employees contain numbers

MySQL Basic Select Statement: Exercise-17 with Solution

Write a query to check if the first_name fields of the employees table contains numbers.

Sample table: employees


Code:

-- Selecting all columns from the employees table
SELECT * 
-- Selecting data from the employees table
FROM employees 
-- Filtering the result set to include only rows where the first_name column contains a digit
WHERE first_name REGEXP '[0-9]';

Explanation:

  • This SQL query selects all columns (*) from the employees table.
  • The WHERE clause filters the result set to include only those rows where the first_name column contains a digit.
  • The regular expression [0-9] matches any digit from 0 to 9 in the first_name column.
  • This query is useful when you want to find employees whose first names contain numeric digits, such as "John123" or "Mary2".

MySQL Code Editor:

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

Previous: Write a query to get the length of the employee names (first_name, last_name) from employees table.
Next: Write a query to select first 10 records from a table.

What is the difficulty level of this exercise?



Follow us on Facebook and Twitter for latest update.