fenway

I see a lot of PHP code -- what I meant was produce an SQL query that will find the most recent one. Then the join will be more obvious.

Well, like I said, this isn't what a database is for. But the bitmask method well work -- why give up/

That's not pretty. I suppose you can treat the entire set of requirements -- binary -- as flags of a bitmask, and then just binary "OR" them together.

Indirectly -- all things being equal, a larger cache will tend to keep more cache records, and assuming a random distribution (never true) of updates and inserts, they would persist longer. But who cares how long they stay? They remain as long as they're valid.

Any is different than all. Please give us a real example.

"all" the columns that match? That's not a job for a database.

Ah yes -- you can't examine any conditions in the WHERE clause for LEFT JOIN'ed table columns -- move them to the ON condition.

First, forget about the joins -- write the query that will find the most recent values that you want.

No, that's what you type. Show us the procedure that is stored in the database.

You know, you can submit null, too.

Show us the actual procedure that was created -- as mysql has it stored.

I still don't follow.

LEFT JOIN twice -- see if thath elps.

Yes, there is a more efficient way -- first grab the latest row, then join back.

There is no array type column.

Forget the syntax. Describe your use case.

You can use the same expression in your ORDER BY clause, and that row will sort first.

What do you have thus far?

The query cache will persist until something that relates to it is updated -- or a newer entries bumps it out (FIFO).

Yeah, a simple join should do it.

You're going to have to ask us the underlying question, because "time" makes no sense.

It's silly to use it without an index.

Show us the current output, and what you think is wrong.

You don't use GROUP BY to select a specific row -- that's what WHERE clause is for.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=353570.0