What version of mysql are you using? On what platform/OS? Is that the exact query, or a simplified representative? What results do you get? IT might be helpful if you included the results of SHOW CREATE TABLE documents and the result of EXPLAIN on your query.
Michael
Schalk wrote:
Why is the following query returning doctype's different to what is asked for?
SELECT * FROM documents WHERE jstate = 'California: State Court' AND doctype = 'Verdict'
Any ideas?
Kind Regards
Schalk Neethling
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]