Query Change from Hour ro Minute

[dweb]

Hi everyone

 

I have this Query

SELECT *, IF(HOUR(TIMEDIFF(NOW(), datetime)) >= 1, 1, 0) AS OlderThanAnHour FROM people_and_staff

Which works great, and shows me all the records in the last hour

 

How can I alter this to show me records in the last 3 minutes?

 

Thank you

[Barand]

Search for rows

 

WHERE datetime BETWEEN NOW() - INTERVAL 3 MINUTE AND NOW()

[dweb]

Sorry, my mistake

 

I don't want to just show the ones in the last hour

 

i want to set the value 'OlderThanAnHour' to 0 if the record was added in the last 3 mins, and 1 if the record was added later than 3 mins ago

 

Is that possible by altering my Query a little?

[DaveyK]

You could do a case, but why not process it in your code

[dweb]

Someone said it was faster to do it in the Query than in code, but i'll take your advice, thanks

[Barand]

SELECT IF(datetime BETWEEN NOW() - INTERVAL 3 MINUTE AND NOW(), 0, 1) as olderThan3mins ...

[dweb]

Awesome thanks