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
Thanks Hugh,
The quotes work. Also is there a way to do exact matches with bif:contains,
for example a query to get all the people whose name is exactly "jack jill".
Kunal
Hugh Williams wrote: Hi Kunal,
The following query should work:
select *
from
where {?s foaf:Name ?name . ?name b
Hi Hugh,
If you have time, I would really appreciate any suggestion/answer for
the question about full text index queries:
In 5.0.6, has the requirement for embedding the encoding in the query
string still there ?
I.e., I want to use non-latin-1 codepoints in the query string and
my server is se
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
Hi Kunal,
The following query should work:
select *
from
where {?s foaf:Name ?name . ?name bif:contains "'jack jill'" .}
Note the addition of single quotes within the double quotes which is
how we handle phrases in bif:contains.
Best Regards
Hugh Wiilliams
Professional Services
OpenLink S
On Fri, Apr 25, 2008 at 2:11 AM, Kunal Patel wrote:
> Hi,
>
> How can I use bif:contains predicate for a string value with multiple
> words. For example when I run the following query it works fine,
>
> select *
> from
> where {?s foaf:Name ?name . ?name bif:contains "jack" .}
>
> But tryin
Hi,
How can I use bif:contains predicate for a string value with multiple words.
For example when I run the following query it works fine,
select *
from
where {?s foaf:Name ?name . ?name bif:contains "jack" .}
But trying to run the query below doesn't work.
select *
from
where {?s f
