I want to port old SQL telephone numer database to OrientDB. The database instead of full 11-digit tel. numbers contains prefixes ( e.g.) +38, +391, +3912. Then I search for all records which start the given full telephone numer:
select * from prefixes where ‘+39123412341’ like prefix || ‘%’;
Assuming that the table contains the following prefixes ( +38, +391, +3912, +392) the query returns ( +391, +3912)
Friends I wonder if such query can be effectively written and executed in GraphQL/OrientDB.
Can anyone of you point me in the right direction.