fenway

Duplicate topic - http://www.phpfreaks.com/forums/index.php?topic=356569.0.

You're working up to a ban with all of this cross-posting.

Don't mark topics solved without posting the solution.

It's unicode -- case-insensitive -- and one of the "general" collations that includes "common" characters.

All these subqueries make me think something is horribly wrong.

Then please post the final working query.

Where's your GROUP BY clause?

SUM() of datetimes doesn't make any sense.

Oh, it can be done -- it just might be easier to calculate in PHP if this is a "one-time" thing, and then update the corresponding rows.

Sorry, I don't understand the question.

Then why not get all the parents first, then a second query to get their children? Or at least process the results sepearetly?

SQL isn't designed to operate on pairs of rows -- you'll have to fake it with a user variable, or use a self-join, assuming you "know" how to find record N+1.

Assuming you told it to do so with mysqldump.

Or you can use NOT EXISTS.

Agreed -- done.

FYI, that would negate the use of an index -- you might want to add a "fake" time to the RVALUE instead.

Please stop posting your code. And you really shouldn't be posting your DB credentials either -- but as you'll notice from the error message, you're not actually using the password.

If you read the posting rules, you'll notice that we'll need much more information to help you.

You'll need a temporary table to do that -- but given the complexity of your query, I think there's something fundamentally flawed.

I always prefer: select columns from table where date <= NOW() + INTERVAL 7 DAY

+1

What?

What's more, if this has to be done by "tomorrow morning", it sounds like a homework assignment.

Then ask mysql for the error.

Yes, except you can't merge * and GROUP BY.