At 16:10 2002-03-06, BadgerBay wrote:
>Hello,
>
>This is a good question for when you are sipping coffee or tea and are
>inspired to write some code. I require additional functionality for my SQL
>search:
>
>MY CURRENT SEARCH
>
>SELECT ID, Authors, Year, Title FROM libraryTable
>WHERE (Authors LIKE '%" + varAuthor + "%')
>OR (Keywords LIKE '%" + varKeyword + "%')
>OR (Title LIKE '%" + varTitle + "%')";
>ORDER BY Year;
>
>ADDITIONAL FUNCTIONALITY REQUIRED
>1) The search should be able to locate singular words when the plural (s or
>es) is entered.
>Example: If "singers" is entered in the search box, than "singer" would be
>found.
1. language-dependent (may not be an issue if all you're using is English - but some
languages are more regular than English so it may be even *less* of an issue if what
you're using is not English!)
2. gammar-dependent:
- not every word that ends in an 's' is a plural (like 'ends' in thi
ssentence, or 'grass')
- irregular (or more exactly ancient) plurals: child-children
to correctly detect plurals you need at least a basic "knowledge" of grammar - and
a dictionary.
--
Marjolein Katsma
HomeSite Help - http://hshelp.com/ - Extensions, Tips and Tools
The Bookstore - http://books.hshelp.com/ - Books for webmasters and webrookies
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
