fenway

Use CASE.

Too complicated -- prove that getting the AVG as a subquery works first.

Oh -- that is strange.

That's a known issue with excel. As I mentioned earlier, just clean it up with a regex.

You can extract that portion from your field -- of course, that won't use an index.

Everything is "doable". But what's the difference between 1 and +1?

No inconvenience -- I just have no idea what you're referring to.

You're going to have to figure out how to explain the actual problem, or I won't be able to suggest anything.

Sorry, I don't follow.

Huh?

I don't follow -- you want to ensure that all 3 conditions are met?

1 & 2 have to do with sql injection -- it's a good idea to quote literals regardless. 3/4/5 are php variable iterpolation issues.

No -- you should know what table you have. If not (!), use SHOW TABLES and keep track.

Sounds like you need to get your hands on a good tutorial.

What produced that CSV file? it looks like your double-quotes are being escaped by double-quotes -- easy enough to fix with a good text editor.

I don't understand the question.

I don't follow.

ultrus has the right idea.

Adjusted how?

Sorry, I don't follow.

Or you could just derive a view on-the-fly -- or similar solution.

Well, I still don't see why a simple scalar subquery won't work.

Actually, there's a sticky somewhere -- maybe in the child board.

Then you must be using the wrong password.

Well, you can still use the alias "avgscore" in the HAVING clause -- but actually, I didn't realize that score was a real column. Re-reading your original post, why not simply use a column subquery to grab the AVG()?