Find rows in table A where table B = 'hello' AND table B = 'world'

That's a lousy subject line, but I don't know how to describe this problem. I've been banging my head against this for a couple of days, and I'm certain there's a simple solution I'm missing. I've got a URL table, a keyword table, and a joining table, so each URL has a list of keywords applied

Replication, Windows, Modems

Hi, hoping someone's come across this before: I need to replicate data between two copies of MySQL, both running on Windows XP. The amount of data is tiny - maybe 35k a day as an upper bound. It's basically monitoring data from a remote device. The problem is that neither machine is

Missing row

Hi, small but disturbing oddity, this. I have a simple table: CREATE TABLE musician ( musicianid int(10) unsigned NOT NULL auto_increment, name varchar(60) NOT NULL default '', PRIMARY KEY (musicianid) ) Type=MyISAM; There are 50 or so lines in the table. I inserted 2

Select where A is not a member of B

Hi - I've got an annoying problem here, I've checked books, web, archives, etc, but can't find anything suitable so far. I have 2 data tables (ignoring the other columns, not important) : ++ | user | ++ | userid | ++ ++ | list | ++ | listid |