Anyone ever done a successful fulltext query with MySQL 3.23.58?

[ppowell]

Here is my query:

SELECT image.id, image.image_name, count(image.id) AS score , image.image_path, image.image_creation_date FROM image LEFT JOIN image_person_assoc ON image_person_assoc.image_id = image.id LEFT JOIN person ON person.id = image_person_assoc.person_id LEFT JOIN image_keyword_assoc ON image_keyword_assoc.image_id = image.id LEFT JOIN keyword ON keyword.id = image_keyword_assoc.keyword_id LEFT JOIN image_event_assoc ON image_event_assoc.image_id = image.id LEFT JOIN event ON event.id = image_event_assoc.event_id LEFT JOIN image_placement_assoc ON image_placement_assoc.image_id = image.id LEFT JOIN placement ON placement.id = image_placement_assoc.placement_id WHERE MATCH (image_name, image_alt, image_location_city, image_location_state, image_location_country) AGAINST ('green' IN BOOLEAN MODE) OR MATCH (first_name, last_name) AGAINST ('green' IN BOOLEAN MODE) OR MATCH (keyword_name) AGAINST ('green' IN BOOLEAN MODE) OR MATCH (event_name) AGAINST ('green' IN BOOLEAN MODE) OR MATCH (placement_name) AGAINST ('green*' IN BOOLEAN MODE) GROUP BY image.id ORDER BY score DESC, upper(image_name) ASC

Works in MySQL 4.0.10, bombs in MySQL 3.23.58

Ok, so I took out 'IN BOOLEAN MODE' and here are the results:

• Produces no results in MySQL 3.23.58
  Produces no results in MySQL 4.0.10

Again, WITH 'IN BOOLEAN MODE':

• Bombs altogether (errors) in MySQL 3.23.58
  Produces results in MySQL 4.0.10

Could someone provide for me proof that either fulltext indexed queries can work in MySQL 3.23.58 with some work, or that they can never work at all?

Thanx
Phil