fenway

Show us the query, and the output.

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

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?

Nope -- that's just a regex call.

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

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.

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/

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.

I agree with you -- but you're trying to UPDATE it in advance.

You need another table of cateorgies, and another of questions.

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=317387.0

update yourTable AS t1 SET t1.newField = ( SELECT ID FROM yourTable WHERE name = t1.name )

Or add a "sortorder" column.

Great. Now, back to your question -- which code snippet are we talking about/

Well, then it should be pretty straightforward -- assuming each name has only a single ID, and vice versa. Add new columns called animal_id, theme_id, etc. to the appropriate tables -- these will ultimately replace the name lookups. Then simply issue an update to each table, and use a subquery to pull back the ID for each given name. Then you can drop the other columns -- once you've updated your application code, foreign keys, etc.

You can't use GROUP BY and those title fields together.

I'm guessing it's a delimeter issue.