Mysql Query to retrieve data based on values length

Question

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

The first suggestion - read your question once again and say honestly: do you really think it's possible to get what you mean? — zerkms
– zerkms, Commented Nov 22, 2012 at 6:54

Steven Moseley · Accepted Answer · 2012-11-22 07:33:28Z

1

Assuming I understood what you're asking for:

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

answered Nov 22, 2012 at 7:33

Steven Moseley

16.4k4 gold badges43 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1