how to find continuous string or number without spaces in mysql?
In abc table i have phone number field.
In that field i have records like
123456789
123 456 789
12345 5678
787878787
144444444
I want to search only records which not have any space so the query would
give result
123456789
787878787
144444444
So what should be query?
No comments:
Post a Comment