LIKE QBE Operator
Learn to use the _like
QBE operator to filter specific data
from the car racing dataset through simple examples.
Example 3-7 _like
Operator
SELECT JSON_SERIALIZE(data PRETTY) AS data FROM GRAPHQL('
team (
check: {
name: {_like: "%Honda%"}
}
) {
id: team_id
name
points
}
');
The above example would fetch the id
,
name
, and points
information from the
team
table where the field name
contains the
string Honda
:
DATA
--------------------------------------------------------------------------------
{
"id" : 303,
"name" : "Red Bull Racing Honda RBPT",
"points" : 589
}
{
"id" : 308,
"name" : "RB Honda RBPT",
"points" : 46
}
2 rows selected.