fenway

HuH/

I don't follow.

Post the actual, raw query, not php code.

Don't store flags in the db.

Next time, how about posting your solution ?

None of this matters. You need to store a clean version of your strings, depending on how you're searching. Substring matches depend on the content, same with the definition of "alphanumeric', the list goes on. Without true full-text searching (i.e. stemming, etc.), this is all smoke and mirrors.

Cron jobs are much, much, much more reliable than replication.

Yeah, but that's evil data storage.

You're new -- next time, use code tags.

Did you explicit grant the drop privilege?

There are countless blog posts on this kind of thing.

You just need to join twice, and count the number of posts.

That's not English.

That's a cron job.

That's a php question related to entities.

Join twice.

That's because not every OS is case sensitive. But don't ever use mixed case.

Sending how? If it's just another accessible mysql server, then it's a joke.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.

At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets (PDF).

This resource covers a very broad range of topics... it's worth a look, though, especially if you're stumbling in the early stages of configuration.

Basically, this blog contains a regularly-updated run-down of MySQL functions, with a short description and a few hints on how to use them; RSS feed here.

Please read the excellent FAQ thread on this issue by our very own wildteen88.