Saturday, February 28, 2015

MySql Query to find longest matching prefix

SELECT num_prefix FROM nums
  WHERE '12684041234' LIKE CONCAT(num_prefix,'%')
  ORDER BY num_prefix DESC
  LIMIT 1
;

No comments:

Post a Comment