• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

Search Based Tool

I need to come up with technologies and tools that will address below requirement.

Requirement: To develop and/or use web based search tool that will allow a user to enter a phrase and it should display the results based on what it points in the database. For example, If we have a list of all tooth pastes in the data base than when a user enters in search box " tooth paste or collegiate or any other phrase related to tooth paste" system should display toothpastes or anything related to tooth paste. Could somebody tell me what tools are available (prefer open source) in the market that we can use and/or if we have to develop in house what technologies we should use.

Thanks in advance.
  • 2
1 Solution
MySQL is capable of full text searching:


though i notice that PhpMyAdmin uses LIKE '%search-phrase%' on all columns (i suspect for reasons of performance)
puja101Author Commented:
Thanks! Has anyone used Apache lucene, if so can we use it with MYSQL?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now