I'm performing a boolean full-text in MySQL and searching three columns in two tables: tbl1.title, tbl1.desc, tbl2.comment. However, with tbl2.comment, I only want to search those records where tbl2.comment_code is either 'A' or 'B'.

Thus, I have this WHERE clause:

MATCH(tbl1.title, tbl1.desc) AGAINST('$search' IN BOOLEAN MODE) OR
(MATCH(tbl2.comment) AGAINST('$search' IN BOOLEAN MODE) AND (tbl2.comment_code = 'A' OR tbl2.comment_code = 'B'))

This works, but it can be slow, which I'm guessing is due to the two full-text searches.

Any suggestions on how to make this more efficient?

Thanks!