Hi Hung, as my undestanding, containsall 'b' will return all records where *all values of xMultiValue* property contains "b".
See the documentation http://orientdb.com/docs/2.0/orientdb.wiki/SQL-Where.html#conditional-operators I have found "true if all the elements of the collection satisfy the next condition". Example <https://lh3.googleusercontent.com/-ngFuVWaPdgU/VubeP0QpRAI/AAAAAAAAALc/_TpvBqBXHjYV6igQ0VMm-Ukix9hlCT10Q/s1600/1.png> Only for the record #9:5 the property xMultiValue contains all values "b". The record #9:0 contains also "a", #9:3 contain also "a" and "c" and #9:7 contains also "c" and "c" <https://lh3.googleusercontent.com/-LvT_dCaQmjg/Vubebk-H6YI/AAAAAAAAALg/ifTC0NV1bOMwFniMzuFkuFECoGOYk_WxA/s1600/2.png> <https://lh3.googleusercontent.com/-CVZmagNAtnc/Vube80CtxDI/AAAAAAAAALo/WHA4tJEOkWQjPu5gFwX1zRuEHtX_ozRVA/s1600/3.png> Hope it helps. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
