Search rows back in table mysql

Hi everyone.

My table mysql is:

I try this query and working:

But I do not know the exact location of the rows... can you help me?

re: Search rows back in table mysql

Hey.

Could you explain that a little better?

What exactly are you expecting to happen?
What is actually happening?

P.S.
Be careful with your names. Both 'date' and 'hour' are reserved MySQL keywords, so it is not a good idea to use them as column names. Even tho it may not be a problem in certain situations, it may be in others.

If you do use them, it is best to enclose them in back-ticks (`). That way you can be sure they aren't causing problems.

Also, it is best to always write out database, table and column names is their proper case. In certain situations, 'A' is not the same as 'a'. Best to keep it consistent, and always use one or the other. (See line #8 in the query you posted)

re: Search rows back in table mysql

Atli:

I need showing a time difference between rows.

If a.DIST=b.DIST and a.DATE=b.DATE and strDiff is < 1 hour I need show the rows.

This is my table:

The difference 08:56:05 (ID=15) and 08:47:19 (ID=11) is < 1 hour... only ID=11 is valid, ID=15 is not valid...

In the table mysql I do not know the exact location of the rows ...

You understand me?