Web Development

General discussion


Need Solution for Complex Search Criteria using Mysql / PHP

By sravanthi ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Google search appliance

by rons.himself In reply to Need Solution for Complex ...

if cost is not an issue, i would suggest the google appliance, we implemented in on a huge mysql database (1.54Million) records.

Collapse -

index table

by self In reply to Need Solution for Complex ...

You would probably have to build an index table
containing the condensed version of each sentance

Harry Potter and the Chamber of Secrets
Lord of the Rings

In the condensed Index Table, these combinations would
all relate:

You would have another table disowning certain words
such as "a, the, and" etc.

Related Discussions

Related Forums