Mysql Regular Expression For Mobile Number?
-
the format must be (01 03 04 05 06 07 08 09)|(70 71 76)-XXXXXX where X can be any number from 0 to 9. A working example would be: 03-769112 or 71-682315 or 09-001241. I made myself a PHP regular expression that works very well for this and it's: "#(([0]{1}[1:3-9]{1})|([7]{1}[0-1:6]{1})… From what I have read Mysql regular expressions look 95% similar to PHP ones. but i cant make one to work.. the mysql query I'm using btw is: ALTER TABLE `users` CHANGE `Tel` `Tel` VARCHAR( 9 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL REGEXP '/^(([0]{1}[1:3-9]{1})|([7]{1}[0-1:6]{1}… that gives the following error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REGEXP '/^(([0]{1}[1:3-9]{1})|([7]{1}[0-1:6]{1}… at line 1 .. what needs change? please help me I'm a mysql beginner. thanks.
-
Answer:
This could be the technical issue... Report it to the service to get things fixed..... Good luck!
[E][M] at Yahoo! Answers Visit the source
Related Q & A:
- How To Find Tamilnadu Mobile Number?Best solution by answers.yahoo.com
- How To Get Girls Mobile Number?Best solution by Yahoo! Answers
- How To Find Mobile Owner From Mobile Number In India?Best solution by mobilegyaan.com
- Is there any pdf reader that supports word searching with regular expression?Best solution by Super User
- How can you change your mobile number at the yahoo messenger? wherein you can log in mobile?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.