fenway

Sounds like you need a JOIN.

Why not??

The best, period.

Not sure why you chose TIMESTAMP instead of DATETIME... TIMESTAMP has all sorts of buggy unexpected "features". Huh? Why are you converting?

Don't mix the two... just use the first one -- but you're missing the JOIN condition!

I'm still very confused why you're confused... don't you get back the category as one of the fields?

The reason you're having trouble is that your tables aren't normalized -- see the stickies.

You need to use LOAD DATA INFILE.

Does the event scheduler in 5.1 allow for this? I've never used it... so I'm just asking.

How come we're talking about code that you haven't "stated"?

Sounds like you need REGEXP and to replace * with %

Where are these duplicates coming from? are there many to many relationships

Don't double post.

You were having other issues with SPs... what's the problem?

How are you calling this? Do you have the CLIENT_MULTI_RESULTS flag set?

FIND_IN_SET() will work, but only with numbers, and it's not fun to edit.

Yup... Sphinx.

Please echo the actual query.

Yikes! I think you mean UNION.

Let's see some sample data.

No problem... enjoy!

Well, that's one way...

Hmm... I wonder if that's related to this?

You think mysql has poor date functionality? Seriously??? Try working with mssql.

Did you try moving it "up" the join list? Your table order isn't explicit....