Jump to content

Archived

This topic is now archived and is closed to further replies.

k4pil

quick database syntax query

Recommended Posts

The below is not working

SELECT *
FROM activity
WHERE userID = 2 AND WHERE time
BETWEEN 19700101020000
AND 20060606000000

Im am trying to get all rows where userID is 2 and time is between those two numbers.

Any help?


ive somehow solved it by rearranging -

SELECT *
FROM activity
WHERE WHERE time
BETWEEN 19700101020000
AND 20060606000000
AND userID = 2

Share this post


Link to post
Share on other sites
Remove the second "where":
[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * [color=green]FROM[/color] [color=orange]activity[/color] [color=green]WHERE[/color] userID [color=orange]=[/color] 2 [color=blue]AND[/color] time BETWEEN 19700101020000 [color=blue]AND[/color] 20060606000000 [!--sql2--][/div][!--sql3--]

Ken

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.