fenway

I mean it depends which DB class you're using.

What does the error log reveal?

I suppose you could simply add them as scalar subqueries....

It's not -- that's crazy talk. You're using the (default) case-insensitive collation -- that's a good thing. If you want a case-sensitive match, then collate as BINARY. -- see here.

Show us the query, and the output.

Usually the DB interface class exposes some sort of quote() function... depends on how you're connecting.

Well, it matters a bit, since I don't want to do your homework -- I just don't have the time to solve non-real-world issues (no offense). Maybe someone else will step up to the plate.

What's the perfomance of that subquery alone? And why all of hte left JOINs?

With IS NULL and LEFT JOIN, you'll only get the rows without matches in the other table.

Is this homework?

Well, timeouts are basically errors or sleeping connections -- 60 seconds should be more than sufficient.

Nope -- that's just a regex call.

That's not an option -- just list the column names -- what's the problem?

I'm confused now -- the "project is over"?

Removing tags, html entities, UTF-8 characters, slashes and non-email characters won't help you in you haven't escaped SQL metacharacters.

Your table name looks single-quoted, not in backticks.

And you're missing a WHERE clause.

Show us the EXPLAIN output.

See here.

You can't overcome that easily -- the apostrophe is considered a non-word character, so the index stores "ronnie" and "s" -- and throws out "s" because it's too short. "Ronnies" is a different word entirely. If you want these to be the same, you'll need to strip out apostrophes from the column you're searching -- or, alternatively, store a "cleaned" column value instead, and search this. This is commonplace, since you often need to strip out HTML, too.

I'm not sure I'm clear on what you're trying to do -- you want the IDs as the values/

5 min? That's really high.

If you want row-based access restrictions, youl'll need a VIEW.

MATCH() ... AGAINST() won't help you with "red" and "car' -- the default stopword length is 4.

XML is markup language -- I don't understand the question. That's like asking on HTML can connect to a DB.