How to make a MySql query faster?

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!