Jasper Bryant-Greene wrote: > Michael's solution will not produce reliable results as it will return > at least two results for many different phone numbers, with no way to > tell which is the correct result.
As long as the database contains Abhishek's bogus "XYZ" and "ZXF" records, yes. If the database contains only real country codes, no. Then there will be at most one match for any number, and if the set of country codes is complete there will be exactly one match for any real and complete phone number. Björn Persson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]