From: Eric Bergen
Date: June 28 2004 12:00am
Subject: Re: Query problem
List-Archive: http://lists.mysql.com/mysql/167986
Message-Id: <11b1bd9904062717007e75e8ac@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

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 <schalk@stripped> 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:schalk@stripped
> 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=eric.bergen@stripped
> 
>