OrientDB doesn't support alias in target, so use this: SELECT * FROM status WHERE content = '%a%'
It's not clear the relationship between A and B in your examples. Are you trying to simulate a join? Lvc@ On 14 June 2014 04:17, Vinh Ht <[email protected]> wrote: > $sql = "SELECT * FROM status A, comment B WHERE A.content = > '%a%'"; > // $sql = "SELECT A.content, B.content FROM status A, comment B > WHERE A.content like '%" . $a . "%' or B.content like '%" . $a . "%'"; > > $queryResult = $this->_db->command(OrientDB::COMMAND_QUERY, > $sql); > => error > > -- > > --- > 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.
