I'm looking for a method for stripping certain characters from a string before searching for it.
The reason is that the user may search for a string such as A34/67 and at may exist in the database as A34-67.
My plan is:
(a) Create a query that will strip all / and - characters from the searchable field
(<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=8426&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> When the user types in a search term strip all / and - characters
© search for the stripped search term in the database
Any ideas about how to do this in phprunner would be appreciated.
Thanks
Suhada