[RESOLVED] stripping non-alpha characters from MySQL

[perpetualshaun]

Hi,

We've developed a labeling / tracking system for one of our clients. The number that's generated is a combination of the customer's ID number, lab ID and an auto-increment ID number. To keep it straight, we're storing the label numbers in MySQL like this: 0003-0058-00001

HOWEVER, we didn't have enough space on the label to include the dashes. So when our customer uses the admin we built for them and does a search for a particular label, they'll be searching for a label number WITHOUT any of the dashes, like this: 0003005800001

So the question is... how can I write a query that will match those up? I'm hoping there's something in MySQL that I can add to my query to just strip out the hyphens. Any ideas?

SELECT * FROM labels WHERE ????? label_number='0003005800001'

Thanks,
Shaun

[Installer]

SELECT * FROM labels WHERE REPLACE(label_number, '-', '') = '0003005800001'