Hi All, We have a requirement to persist the data with ", (Comma)" for one of the fields. Here is the sample data.
@rid@version@classnamequalification#9:0 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:0> 1VvenkatMCA#9:1 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:1> 1VNagMCA#9:2 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:2> 1VAnilB.Tech#9:3 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:3> 1VSuneethB.Tech#9:4 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:4> 1VChaitanyaB.Tech#9:7 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:7> 1VUmakanth"M.Tech", "B.Tech", "B.E, BB" Now, I would like to know the candidates whose qualification is MCA or B.E, BB. For this I am using the below query but its not working. select from V where qualification in ['MCA', "B.E,BB"] @rid@version@classqualificationname#9:0 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:0> 1VMCAvenkat#9:1 <http://172.20.36.201:2480/studio/index.html#/database/Test/browse/edit/9:1> 1VMCANag Could any one of you please suggest me to retrieve the data correctly. Thanks, Venkat -- --- 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.
