MySQL Forums
Forum List  »  Newbie

SQL Problem
Posted by: Bruce Julseth
Date: December 08, 2011 11:25AM

The following SQL only returns information for the "bridelast"

SELECT eventid, groomfirst, groommiddle, groomlast, bridefirst, bridemiddle, bridelast, eventdate
FROM marriages
WHERE (groomlast LIKE 'jul%') OR (bridelast LIKE 'jul%')
ORDER BY groomlast,groomfirst LIMIT 0,5

What is wrong?

If I delete the bridelast clause, the groom information is returned.

Thanks...

Bruce

Options: ReplyQuote


Subject
Written By
Posted
SQL Problem
December 08, 2011 11:25AM
December 08, 2011 11:31AM
December 08, 2011 04:15PM
December 08, 2011 04:59PM
December 08, 2011 05:40PM
December 08, 2011 05:46PM
December 08, 2011 07:48PM
December 09, 2011 01:43AM
December 10, 2011 11:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.