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', '%');
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.