fenway

Why bother doing it all in sql since you're already forced to deserialize() in php?`

My pleasure... sorry for the 2-week delay.

Please indicate how this was "solved" before marking it such.

Ok... seems to work for me... try this: CREATE OR REPLACE VIEW dup_checks AS SELECT LEFT(tbr.Forename, 1) AS Forename, tbr.Surname, LEFT(tbr.Addr1, 5) AS Addr1, tbr.Postcode FROM test_suppress INNER JOIN tbr use index (`both`) ON (test_suppress.surname=tbr.surname AND test_suppress.postcode=tbr.postcode) where LEFT(test_suppress.forename, 1)=LEFT(tbr.forename, 1) AND LEFT(test_suppress.addr1, 5)=LEFT(tbr.addr1, 5) And select * from test_suppress INNER JOIN dup_checks use index (`both`) ON (test_suppress.surname=dup_checks.surname AND test_suppress.postcode=dup_checks.postcode) where LEFT(test_suppress.forename, 1)=LEFT(dup_checks.forename, 1) AND LEFT(test_suppress.addr1, 5)=LEFT(dup_checks.addr1, 5) Hope that helps.

Not exactly... no join condition! Try: select c.user_id, count(*) as cnt from cars as c inner join user as u on ( u.id = c.user_id ) group by c.user_id having cnt < 3

Isn't here an "upload"?

select user_id, count(*) as cnt from cars group by user_id having cnt < 3

Oops, missed the "everything" part...

Only if you want to judge the quality of these forums based on the rantings of a single individual... Entirely uncalled for -- if you don't understand, then don't respond. You've been warned.

Sounds like you need some cross joins....

That error message means you didn't execute a sucessful query... but MAX(id) is the better way to go... the question is why you need this.

I'm not sure what you mean by this.

You have multiple statements in your TRIGGER, so you can't use ";" to end your statements and your trigger -- you need to change the delimiter first.

Silly me... both is a reserved keyword... I had no idea. SELECT e.* FROM events AS e INNER JOIN ( SELECT `organization_id` FROM `events` WHERE MATCH (events.theme, events.contact_name, events.contact_email, events.contact_phone) AGAINST ('southern' IN BOOLEAN MODE) UNION ALL SELECT `id` AS organization_id FROM `organizations` WHERE MATCH (organizations.church_name, organizations.city, organizations.contact_name, organizations.email) AGAINST ('southern' IN BOOLEAN MODE) ) AS sub ON ( sub.organization_id = e.organization_id ) My bad.

You assume? Didn't you check? How are they separated?

That's great -- the EXPLAIN should indicate that FULLTEXT is being used for both ... and I would all UNION ALL to save a filesort. All of you need to do know is join the events to able to this union'ed table: SELECT e.* FROM events INNER JOIN ((SELECT `organization_id` FROM `events` WHERE MATCH (events.theme, events.contact_name, events.contact_email, events.contact_phone) AGAINST ('southern' IN BOOLEAN MODE)) UNION ALL (SELECT `id` AS organization_id FROM `organizations` WHERE MATCH (organizations.church_name, organizations.city, organizations.contact_name, organizations.email) AGAINST ('southern' IN BOOLEAN MODE)) ) AS both ON ( both.organization_id = e.organization_id )

Yes, but the error message you posted is from the query in the commented code -- so what's the actual problem?

Forget the JOIN for a minute... just UNION each table with it's own FULLTEXT index.

I still have no idea what the M_addtn field looks like, I'm sorry. You're describing the destination, not hte souce.

Huh? I'm talking about: /*$entered = "UPDATE $player SET gm1 1 = 'Giants' WHERE id ='10' LIMIT 1" ; $entered = "UPDATE $player SET gm1 1 = $pick WHERE id = '$myid'";//$p_name $result = mysql_query($entered, $link) or die (mysql_error());*/ [code] [/code]

the atrribute for it says BINARY, thats all that is list Field: m_addtn Type: blob Attribute: binary Null: No The format of the data being stored inside this field.

Well, a FULLTEXT index (or any index, for that matter) cannot cross tables, so that's why you need to use separate MATCH...AGAINST clauses. But why not just UNION the results of two separate queries?

That doesn't answer my question... what is the format of this BLOB field?

Not only that, but your column name has a space in it????

Good ol' DOS->UNIX issues.