searching for sku with or without dashes
Posted: Wed Jan 17, 2007 10:06 pm
I have a table (which I have no control over) which has some of its products skus listed with dashes (010-00433-00) and some without (0100043300). How would I
and have it find 010-00433-00 or 0100043300
does it require regex? I hope not
Code: Select all
SELECT id FROM products WHERE sku = 0100043300does it require regex? I hope not