SELECT PHONE, CHAR_LENGTH(PHONE) AS 'Charather Size' FROM user_details WHERE CHAR_LENGTH(PHONE)>10; +------------------------------+------------------+ | PHONE | Charather Size | +------------------------------+------------------+ | 08686501615 | 11 | | 918143716151 | 12 | +------------------------------+------------------+ 2 rows in set (0.00 sec)
Comments
Post a Comment