Re: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Marjolein Katsma
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 LIK

RE: SQL coding: Finding singular when search with plural.

2002-03-06 Thread Adam
I'm assuming your users arnt using a MySQL client directly to perform the queries... And your using middleware like PHP or something. So your PHP code can parse the users responses and then design your SQL queries around your parsed data. -Original Message- From: BadgerBay [mailto:[EMAI