The EXIST() function Previously, searching in non-existing fulltext fields was possible using @@relaxed operator, but attributes didn't have anything similar until now. The EXIST() function is an equivalent of @@relaxed, but it is specifically to be used for attributes: SELECT *, EXIST('gid', 6) as cnd FROM i1, i2 WHERE cnd>5 This example will return results only from the index that doesn't have the "gid" attribute.
No comments:
Post a Comment