Hi Curtis, the inner SELECT is not valid. You should put a FROM. SELECT FROM Application WHERE symbol MATCHES '(^[[:<:]]B62D 6[[:>:]]*)') AND symbol MATCHES '(^[[:<:]]B60[[:>:]]*)'
? Lvc@ ᐧ On 20 August 2014 12:50, 'Curtis Mosters' via OrientDB < [email protected]> wrote: > Hey guys, I don't want to waste too much time in my first "big" example. I > need to transform a simple query from MySQL into OrientDB query. > > Homefully someone of you could quickly help me. Otherwhise I need to spend > some time testing, that's ok. Alright (btw I neutralized the names): > > SELECT ipc1.id > FROM ( > SELECT ipc.id > FROM table1 ipc > WHERE ipc.symbol REGEXP '(^[[:<:]]B62D 6[[:>:]]*)' > LIMIT 0, 100 > ) AS ipc1 > JOIN ( > SELECT ipc.id > FROM table1 ipc > WHERE ipc.symbol REGEXP '(^[[:<:]]B60[[:>:]]*)' > ) AS ipc2 > ON ipc1.id = ipc2.id > > Just in my minds I would do something like: > > SELECT id FROM Application WHERE (SELECT symbol MATCHES '(^[[:<:]]B62D > 6[[:>:]]*)') AND WHERE (SELECT symbol MATCHES '(^[[:<:]]B60[[:>:]]*)') > > Application is the new class btw. If I test this I just get: > > com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error > on parsing command at position #111: Invalid keyword 'SELECT' Command: > SELECT id FROM Application WHERE (SELECT symbol MATCHES '(^[[:<:]]B62D > 6[[:>:]]*)') AND WHERE (SELECT symbol MATCHES '(^[[:<:]]B60[[:>:]]*)') > -----------------------------------------------------------------------------------------------------------------------^ > > Ohh and please don't say I should merge both id's. Maybe that's a good way > for later on or so. But for now let's take it easy and just transform the > query =) Thanks. > > -- > > --- > 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. > -- --- 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.
