Post the table structure, what that query it returning and what you
think it should return.
On Sun, 27 Jun 2004 23:33:55 +0200, Schalk <schalk@stripped> wrote:
> Why is the following query retuning doctype's different to what is asked
> 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
> Tel: +27125468436
> Fax: +27125468436
> 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/mysql?unsub=1