MySQL Forums
Forum List  »  Full-Text Search

null columns in full text search
Posted by: Andrew Groh
Date: August 25, 2005 03:15PM

I am trying to do a full text search where one of the columns may be null. For example

select * from t_document d, t_author a left join d.author_id = a.author_id
where MATCH(d.title,a.name) against ("something" in boolean mode)

The problem is that the document may not have an author and therefore a.name may be null. So even if "something" is in the document title, the row is not returned if the a.name is NULL. Is this the correct behavior (I am familiar with how NULL works in other contexts, and why it is not an empty string)? Is there a way I can work around this?

Andrew

Options: ReplyQuote


Subject
Views
Written By
Posted
null columns in full text search
3380
August 25, 2005 03:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.