MySQL Forums
Forum List  »  GIS

Re: function CONTAINS()
Posted by: Hartmut Holzgraefe
Date: October 07, 2009 12:32AM

Contains() is currently just an alias to MBRContains(), see the first note on

http://dev.mysql.com/doc/refman/5.1/en/functions-that-test-spatial-relationships-between-geometries.html

and the section on MBRContains(), which has a usage example, on

http://dev.mysql.com/doc/refman/5.1/en/relations-on-geometry-mbr.html

If you are looking for an equivalent to the MS SQL function CONTAINS() you have to use the LIKE operator or MATCH ... AGAINST if you are checking for words on a fulltext indexed column ...

--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

Options: ReplyQuote


Subject
Views
Written By
Posted
23245
October 06, 2009 06:32PM
Re: function CONTAINS()
14112
October 07, 2009 12:32AM


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.