Stuart Felenstein wrote:
I built the query.The returned values should be exact. As far as how much data, I'm assuming your talking about amount of records ? Potentially eventually maybe quite a bit. Currently mysql statement is comprised of select and from with all the proper joins. But I"m confused, when you say below actual SQL call here, is the referring to the SQL statement that would look at all the imput values and process the data ? like a series of and's or or's ?
You need to execute it and read the returned set.
I don't know what language you are using, so I did not go into detail.
The trick is to use 'LIKE' and append the '%' wildcard to the values entered.
Now you can use AND between each condition.
You must be sure to properly quote each string using the languages quoting function.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
