Post the table structure, what that query it returning and what you think it should return.
-Eric On Sun, 27 Jun 2004 23:33:55 +0200, Schalk <[EMAIL PROTECTED]> wrote: > > Why is the following query retuning doctype's different to what is asked > for? > SELECT * FROM documents WHERE jstate = 'California: State Court' AND doctype > = 'Verdict' > > Any ideas? As far as I can see it should only return a document if it is a > Verdict and matches the state California: State Court. > > Kind Regards > Schalk Neethling > Web Developer.Designer.Programmer.President > Volume4.Development.Multimedia.Branding > emotionalize.conceptualize.visualize.realize > Tel: +27125468436 > Fax: +27125468436 > email:[EMAIL PROTECTED] > web: www.volume4.co.za > > This message contains information that is considered to be sensitive or > confidential and may not be forwarded or disclosed to any other party > without the permission of the sender. If you received this message in error, > please notify me immediately so that I can correct and delete the original > email. Thank you. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
