🚀 go-pugleaf

I have 2 tables one with college faculty and one with course information. I have a third table (a table of courses offered in the fall) that is related to the other two by faculty_ID and class_ID respectively. I set up the indexes on the first two tables and I can do match searches for them in MySQL. The only information in the third table that some one would be interested in is the who the instructor is (represented by the faculty_ID) and what class it is(represented by the class_ID). Since these are integers I can't do a full text matching on those fields .

I tried joining and adding the $where clause like so

// SELECT * FROM faculty_info, comm_classes, fall_classes WHERE faculty_info.faculty_ID = fall_classes.faculty_ID and comm_classes.class_id =fall_classes.class_ID and MATCH (faculty_info.faculty_first, faculty_info.faculty_last, comm_classes.class_name, comm_classes.cat_num, comm_classes.class_desc, comm_classes.prog_study) AGAINST ("Joan, Atkins")

but I get the error #1210 Wrong arguments to MATCH. I tried putting the Match statement first but it didn't work either. Is this possible or am I wasting my time?