On Sat, 18 Sep 2004 23:57:59 +0200, Schalk Neethling <[EMAIL PROTECTED]> wrote: > If I submit the following query: > > SELECT * FROM mi_verdicts_search WHERE doctype = 'Verdict' AND (state = > 'California: State Court' OR district = 'Circuit Court: Federal, Alaska' > OR appellate = 'US Supreme Court') AND speciality = 'Contracts' > > When will a result be returned? When all of the statements in brackets > find a result or if any of the three in brackets get's a result?
A result will be returned when doctype and speciality are matched, along with any one (or more) of the statements in your parenthesis. If nothing in the parenthesis match, no result will be returned. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
