3 messages in com.mysql.lists.mysqlRe: AND + OR Logic
FromSent OnAttachments
John Berman12 Feb 2004 13:11 
jabb...@abbotts.org12 Feb 2004 13:22 
John Berman12 Feb 2004 13:44 
Subject:Re: AND + OR Logic
From:jabb...@abbotts.org (jabb@abbotts.org)
Date:02/12/2004 01:22:50 PM
List:com.mysql.lists.mysql

On Thu, 12 Feb 2004, John Berman wrote:

Try adding some ()s:

SELECT * FROM marriage WHERE (groom_surname like ('"& globsurname & "') or bride_surname like ('"& globsurname & "')) and community like ('"& community & "')

--