fenway

There is an entire section in the mysql refman devoted to this.

That's all PHP-side, not in the DB.

I have no idea what that means.

So, just use multiple name=val for SET.

Sorry, I don't follow.

You'll need to echo the queries you're producing.

It was probably a backwards-compatibility issue... but the first one is preferred for multi-valued options.

Then you need to build the WHERE clause dynamically.

Well, you can drop all of the privileges, but that seems like overkill... just check the GRANTs for that user.

Yes, you can replace the ORs with ANDs -- of course, it means something different. And yes, that's correct -- you need ANDs if you want all 4 to match.

Or DATE?

No, that's wrong -- LIKE is not associative. select * from table where (col1 like '%apple%' or col2 like '%apple%' or col3 like '%apple%' or col4 like '%apple%')

You can't use an aggregate expression in WHERE, only HAVING.

Please use the code tags, we have them for a reason.

Don't ever change them -- ever.

Huh?

That's not going to work in the general case.

Did you try the queries you where given?

Then why not check the max value for the max date in that range?

Not sure I understand -- you want the update syntax, or a trigger?

Sorry -- you want to make it 10000 if it's zero?

If you didn't have the log turned on before, it's not going to help to turn it on now.

This really isn't the correct place for php parsing errors.

You posted your DB credentials to the world -- I'd change them, NOW. And define "didn't work".

50M is nothing.