MySQL Forums
Forum List  »  Data Warehouse

Best Match from the left
Posted by: goh juno
Date: May 16, 2011 03:26AM

Suppose i have a list of numbers
2243432422
5645343425
4252524245
6756345234
7809080594


And i got number 56488888888.


I want the query to get 5645343425 which is the best match from the left. Is there a query that can do that ??


I tried with query below but no luck.

SELECT * FROM table
WHERE number LIKE CONCAT('56488888888', '%');

Options: ReplyQuote


Subject
Views
Written By
Posted
Best Match from the left
5022
May 16, 2011 03:26AM
1938
May 17, 2011 11:40PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.