CODEWITHSUNDEEP
mysqlstringnumbers
pjau
pjau

Reputation: 925

Check if a string contains numbers

How do I check if a string in a MySQL field contains a number then delete them?

Example table:

tbl_tags
 -------------
| id | tag    |
 -------------
| 1  | hello  |
| 2  | hello2 |
| 3  | 2hello |
| 4  | hel3lo |
 -------------

The only way I can think of is to do each number individually and use LIKE '%1%' OR LIKE '%2%' etc. But there must be an easier way?

Upvotes: 34

Views: 65492

Answers (2)

user3200518
user3200518

Reputation: 131

SELECT * 
FROM clients
WHERE name REGEXP '^[[:digit:]]+$'
ORDER BY `clients`.`country_id` DESC 
LIMIT 0 , 30

this is the answer if you're looking for strings with only digits

Upvotes: 13

Jason McCreary
Jason McCreary

Reputation: 72961

Check out the MySQL Regex methods. Something like the following should work.

SELECT * FROM table WHERE tag REGEXP '[0-9]'

Upvotes: 77

Related Questions