Hi I have items in a table identified by a Part Number. The Part Number may be selected by inputting into a php search box (perhaps from users memory).
Example Original 71HF-9601-AB Searched for 71HF 9601 AB or 71HF9601AB or Original 36 44 A9 Searched for 36-44-A9 or 3644A9 or with other separators, though hyphen or space are likely to be the ones. Spacing and formats vary . Is there SQL that says ignore specific characters. If not I am stuck with stripping all the characters and searching with a stripped value. The data comes from 30 or 40 sources and is updated regularly so I am trying to avoid working too hard :) Thoughts from those more expert than me appreciated! Peter --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
