OrientDB count phrase in field

Question

How can I count a phrase instances in a field using OrientDB?

Let's say I have the following data:

Display_title | Description
My_data_12 | The quick brown fox jumps over the lazy dog
My_data_13 | The one

How can I count the number of 'the' instances, output similar to this:

Display_title | Count
My_data_12 | 2
My_data_13 | 1

Answer 1

using @Vitim.us answer from here

you can call it from studio with

select title, occurrences(@this.description, "the") from v

NOTE that this is case sensitive, so with your example you'll get:

 title      | occurrences
 My_data_12 | 1
 My_data_13 | 0