5
It is possible for me to filter the following formatting in a particular mysql field: (21)2222-2222. I ask for the understanding of colleagues if I was not clear in my doubt, because I had a problem in the register of which the mask:
$("#telefone").mask("(99)9999-9999"); was $("#telefone").mask("(99) 9999-9999"); and that gave problem here.
4
You can filter numbers with like using the joker for a character _.
SELECT * FROM tabela WHERE telefone like '(__)____-____'
Related:
show... perfect.. did not know this type of filter... thanks ray, it worked
is not allowing to give as correct answer, only after 9 minutes, but I will return to confirm ;)
@Fox.11 o % be to specify any amount of characters and the _ only one, more in: What is the undescore "_" in the MYSQL LIKE?
Browser other questions tagged php mysql
You are not signed in. Login or sign up in order to post.
Da yes you want to take only the numbers that do not have the
9at first?– rray