On Sat, 26 Jun 2004 22:19:02 +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?
What is being returned? Not knowing what it is that is being returned, how the documents table is defined or what the data types for the fields are it is hard to guess, except to note:
'Verdict' will also match 'verdict' and 'vErDicT' using default settings, see:
http://dev.mysql.com/doc/mysql/en/Case_sensitivity.html
Kind Regards
Schalk Neethling
With a bit more info perhaps I could help more.
Robert J Taylor [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]