...
_ : Matches any single character.
# | Query | Output |
---|
1 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'lang' like '%en%';
|
Code Block |
---|
title | Json Response |
---|
collapse | true |
---|
| {
"lang": "en",
"price": 699,
"title": "The Golden Compass",
"authors": [
"Philip Pullman"
],
"pub_year":1995
}
{
"lang": "english",
"price": 895,
"title": "Feersum Endjinn",
"authors": [
"Iain M. Banks"
],
"pub_year":1994
} | |
---|
2 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'lang' ilike '%En%'; |
Code Block |
---|
title | Json Response |
---|
collapse | true |
---|
| {
"lang": "en",
"price": 699,
"title": "The Golden Compass",
"authors": [
"Philip Pullman"
],
"pub_year":1995
}
{
"lang": "English",
"price": 895,
"title": "Feersum Endjinn",
"authors": [
"Iain M. Banks"
],
"pub_year":1994
} |
|
---|
3 | cpsdb=# SELECT * FROM FRAGMENT WHERE anchor_id = 4 and attributes->>'lang' like 'en'; |
Code Block |
---|
title | Json Response |
---|
collapse | true |
---|
| {
"lang": "en",
"price": 699,
"title": "The Golden Compass",
"authors": [
"Philip Pullman"
],
"pub_year":1995
} |
|
---|
...