How do you check if a column value contains only numeric characters using REGEXP?

Q: How do you check if a column value contains only numeric characters using REGEXP?

In MySQL, you can use the **REGEXP** operator to check if a column contains only numeric characters by using a pattern that matches digits from start to end of the string. The caret `^` anchors the start, and the dollar `$` anchors the end. **Pattern:** Use `'^[0-9]+$'` to match one or more digits from start to end of the string. **Anchors:** `^` ensures matching starts at the beginning, `$` ensures matching ends at the last character. **Character Classes:** `[0-9]` represents any single digit; combined with `+` it matches one or more digits. **Alternative:** `\d+` can also be used in some MySQL versions for digit matching. This approach is useful for validating numeric-only data or filtering rows that contain only numbers. SELECT id, code FROM products WHERE code REGEXP '^[0-9]+$'; SELECT id, phone FROM contacts WHERE phone REGEXP '^\d+$';

Difficulty: 2/10

REGEXP, data validation, MySQL

Using REGEXP to Check for Numeric-Only Values in MySQL

In MySQL, you can use the REGEXP operator to check if a column contains only numeric characters by using a pattern that matches digits from start to end of the string. The caret ^ anchors the start, and the dollar $ anchors the end.

Key Points for Numeric-Only Checks

1
Pattern: Use '^[0-9]+$' to match one or more digits from start to end of the string.
2
Anchors: ^ ensures matching starts at the beginning, $ ensures matching ends at the last character.
3
Character Classes: represents any single digit; combined with it matches one or more digits.

This approach is useful for validating numeric-only data or filtering rows that contain only numbers.

Example: Check Numeric-Only Values

Example: Using \d for Digits

Scenario Questions

0-2 years experience

2-5 years experience

1Our import pipeline sometimes receives SKUs that include letters. How would you adjust the existing query that validates SKUs with REGEXP to catch non‑numeric values, and what performance impact might that have?

Follow-up Questions