Fulltext searching plurals

hey guys,

can someone tell me how to fulltext search and find matches even though the user entered plurals. Example i have the keyword computer in my db which is indexed, and someone types in computers how come it does not find it and how can i make it find it. Do i have to parse using expressions or is there something better i can do? Please help this is very important.

There's nothing built in that will do this.

One possible solution is to create an new field in the database which contains the text you want to search with all plurals removed (eg. use regexp to remove es, ies, etc), and search on this field using the search keywords with plurals removed. Because you will have problems identifying plurals and their singular forms you may want to look into a more general stemming approach (each Porter stemming).

Hadley