在SQL数据库上搜索时是否包含复数词？

Question

Is there anyway to include plural keyword when searching on SQL database?

Almost all of my product database as single keyword only.

Such as searching with blue area rug <-- This would be display the results.

But if searching with blue area rugs <-- This will not display any results.

Thanks

Answer 1

I am not sure this can solve your problem or not.A function 'SOUNDEX' it may help you.

select * from tbl where title like '%rug%' or  SOUNDEX(title) = SOUNDEX('rugs')