Search a formatted number in a MySQL table with a differently formatted search word

Remiz

Remixed version of unstable human emotions and thirst of mankind actions. UX designer, UI developer and HE of WebCastle Media Pvt LTD

2 Responses

  1. jafar says:

    this method is indeed slow(not n hour late :P) .Use “SELECT * FROM `table`
    WHERE `numberes` REGEXP ‘1[() -]*9′” (when you search ’19’)
    Note You need a [() -]* between each input character.Expected data:+1 (003) 534-2343

Talk your view

Read previous post:
Easiest way to type Malayalam – Easy Malayalam Software Download

My friend Anoop MC's Easy Malayalam Software hit 2 million download. Lets celebrate.

Close