petri_28

Hello! I have a following problem with my MySQL. I have a one table called news, and inside that table I have a two colums called time and subject. Time is for example 14:53 and subject is normal string .. If I would like to make a query which would retrieve last subjects from the last for example 10 minutes I have tried this query: Select subject from news where aika between 'select time(current_timestamp)' and 'select time(now()-interval 10 minute)' but it gives me a zero result set .. I think I cannot use that kind of "variables" to generate time , but How I am going to make that query then ? Help needed! Petri