3 Replies Latest reply: Mar 29, 2012 3:13 PM by bregent RSS

    filtering search results

    charmac2013 Community Member

      I am working with php/Mysql and have a table that contains many orders and each order has a long serial number. We often only use the last 4 digits of the serial number when referring to an order. I want to know how to filter my query only by the last 4 digits of the serial number so the orders are easier to reference in our system. Any ideas of how to do this are appreciated. Thanks so much.