Ivan Mikhailov wrote:
Rob,
The sample is not very accurate, "'%Queen%Elizabeth%'" means search for
all words in phrase '%Queen%Elizabeth%' that is, probably, a phrase of
two words, Queen and Elizabeth? with weird delimiters between and around
words. This is search for ?object that is supposed to
Rob,
The sample is not very accurate, "'%Queen%Elizabeth%'" means search for
all words in phrase '%Queen%Elizabeth%' that is, probably, a phrase of
two words, Queen and Elizabeth? with weird delimiters between and around
words. This is search for ?object that is supposed to be a string. There
is n
Rob,
On 30 Apr 2008, at 13:52, robl wrote:
Hugh Williams wrote:
Hi Rob,
The following change to the query should work:
SELECT ?subject ?predicate ?object WHERE {
?subject ?predicate ?object.
?object bif:contains "'%Queen%Elizabeth%'"
}
Note the single quotes around the % characters.
Doesn
Hugh Williams wrote:
Hi Rob,
The following change to the query should work:
SELECT ?subject ?predicate ?object WHERE {
?subject ?predicate ?object.
?object bif:contains "'%Queen%Elizabeth%'"
}
Note the single quotes around the % characters.
Doesn't this match objects rather than subjects
On 21 Apr 2008, at 14:40, robl wrote:
SELECT * FROM pages WHERE page_title LIKE "Queen%Elizabeth"
This would perform a case insensitive match on Queen(anything)
Elizabeth
(at least in mySQL).
...
Is there quick way to do what I want ? Are there any indexes I could
apply to improve thi
Hi Rob,
The following change to the query should work:
SELECT ?subject ?predicate ?object WHERE {
?subject ?predicate ?object.
?object bif:contains "'%Queen%Elizabeth%'"
}
Note the single quotes around the % characters.
Best Regards
Hugh Williams
Professional Services
OpenLink Software
On
-
From: "robl"
To:
Sent: Monday, April 21, 2008 8:40 PM
Subject: [Virtuoso-users] DBpedia and Virtuoso SPARQL Query
Hi,
I'm currently working with the latest DBpedia dataset in Virtuoso OS
Edition (5.06). I'm trying to do the equivalent of a SQL LIKE using
SPARQL on a reso
Hi,
I'm currently working with the latest DBpedia dataset in Virtuoso OS
Edition (5.06). I'm trying to do the equivalent of a SQL LIKE using
SPARQL on a resource subject. So in SQL this would have been something
like :
SELECT * FROM pages WHERE page_title LIKE "Queen%Elizabeth"
This would
