2 messages in com.mysql.lists.win32Query Problem (SQL Statement)
FromSent OnAttachments
Christian Surya21 Dec 2004 18:18 
Patrick Questembert21 Dec 2004 20:40 
Subject:Query Problem (SQL Statement)
From:Christian Surya (csur@gmail.com)
Date:12/21/2004 06:18:53 PM
List:com.mysql.lists.win32

Hi all,

I want to create an SQL Statement but I need help. My table have DateBegin, DateEnding, ScoreBegin and ScoreEnd. I want to select a record which date between DateBegin and DateEnding and score between ScoreBegin and ScoreEnd. I use MySQL Database. I have tried "SELECT * FROM ScoreTable WHERE DateBegin >= <date> AND DateEnding <= <date> AND ScoreBegin >= <score> AND ScoreEnding <= <score>" there is no result using this statement. Can anyone help me?

Thanks in advance

Best Regards, Christian