Need Solution for Complex Search Criteria using Mysql / PHP - TechRepublic
General discussion
December 2, 2007 at 11:34 PM
sravanthi

Need Solution for Complex Search Criteria using Mysql / PHP

by sravanthi . Updated 18 years, 7 months ago

We are looking for a solution to search functionality. In Keyword search end user will give the keyword like “privatepapers”(without space), but in database we are maintaining data as “The Letters and Private Papers of William Makepeace Thackeray” (with space).
How can i get the result of that records containing “Private Papers”, if i enter without spaces (privatepapers) in search.

The following is the example pattern.

Pattern Result Description
harrypotter ~Harry Potter In searches, all occurrences of harrypotter will be replaced by Harry Potter (with a space)
author=Rowling =J.K. Rowling If a search for author matches Rowling, the whole search will be replaced with “J.K. Rowling

This discussion is locked

All Comments