Multiple / Selective SQL Queries

Question

How can I make multiple / singular words stretch all forms?

Example. If a person is looking for “male rings”, how can I check the database to find out if any of the fields contain male, male, male, rings, rings, etc.?

Answer 1

It doesn't seem like using LIKE would be the best approach to what you need. I would look at MySQL FULLTEXT indexing to get basic functionality. I will need to study the plural a bit more to see if this can be done.

Take a look at these two links for FULLTEXT indexing information.

• http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html
• http://www.petefreitag.com/item/477.cfm
• http://dev.mysql.com/doc/refman/5.1/en/fulltext-boolean.html

:

SELECT headline, story FROM news
WHERE MATCH (headline,story) AGAINST ('Hurricane');

UPDATE:

SO , , , , FULLTEXT , , . FULLTEXT?

Answer 2

Sphinx full-text MySQL (. ).

Porter Stemmer [2] [3], , "" , "" , "" "" "" (. wiki).

Answer 3

select * from index_table where item_name rlike '[[:<:]]preform[s]*[es]*[ies]*[[:>:]]';

, . . , 90-95% .

Cheers, Ashish