CODEWITHSUNDEEP
mysql
Adarsh
Adarsh

Reputation: 127

Mysql Query to retrieve data based on values length

Hii Guys!!! i have a table named cdrcost which has dst column.I am need to retrieve the values based on digits in the column values. For example:

dst

0001266 2545 874545565612 25452`

Any suggestion will be welcomed

Upvotes: 1

Views: 172

Answers (1)

Steven Moseley
Steven Moseley

Reputation: 16355

Assuming I understood what you're asking for:

SELECT * 
FROM cdrcost 
WHERE LENGTH(dst) = 31;

Upvotes: 1

Related Questions