fenway

You have no join conditions!

First problem -- that's not a valid mysql date format -- use STR_TO_DATE().

Ah... then you need a LEFT JOIN, or NOT EXISTS.

If you'd like to rank partial substring matches by distances from string position 0, that's not hard to do in application code.

If it's encrypted, you'll need to decrypt it to get it back -- how you choose to encrypt is entirely up to you.

There must be countless ones on this site... I could always move this thread to php board and see what comments you get there.

Assuming you can get these back to timestamps, mysql has function that can convert back & forth -- but why bother to begin with?

That's called an UPDATE.

All you need to do is order the query I provided, and then loop through the resultset in application code.

FYI, if you ever had any other records linked to this table by UID, you'd better clear them out, or reset the auto-increment value, or you'll be sorry.

That has security hole written all over it.

Maybe someone else can help -- I don't feel like interpolating the variables myself when a simple echo() will suffice.

If the "condition" is a null value, COALESCE() works well too.

If you're asking in general how to do this, you should check out a few of the tutorials. If you have a specific question, I can't find it.

Usually, you would use a derived table to grab the min(), and then join it back to the primary table.

That's the less optimal solution, through.

You've been given the easier solution -- one row per hit.

Yes, it's the wrong place -- and more importantly, you're not describing the upload process

Nothing wrong with short aliases... but please show us the actual query being sent to the server.

If you don't have matching records, then your where clause will always be false -- you might need to move it to the ON condition.

It returns one (q,a) pair per row -- that's different.

How did you do it?

Huh?

Hmm... no ORDER BY clause?

My bad... it happens. Thanks for not going bezerk. Your next 100 posts are free :-)