Gossamer Forum
Home : Products : Gossamer Links : Discussions :

SELECT Word_ID like 'someword' problem

Quote Reply
SELECT Word_ID like 'someword' problem
Hi there,

I'm using the internal indexing scheme (i need to find 3 letter words)
and noticed that when I run a query the first query looks like this:

SELECT Word_ID, Frequency FROM links_Links_Word_List WHERE Word LIKE 'event'

the question is why doesn't the query look like '%event%'.
If we're doing a like query than shouldn't that be what it tries to find?
so that it returns event and events

Is this a bug or is this intentional?


thanks and peace.
Quote Reply
Re: [klangan] SELECT Word_ID like 'someword' problem In reply to
Not a bug. GT::SQL::Condition documentation specificly shows in its examples that you need to add wildcard variables yourself.

Philip
------------------
Limecat is not pleased.
Quote Reply
Re: [fuzzy logic] SELECT Word_ID like 'someword' problem In reply to
Thank you for the info. Most helpful.

peace.
Quote Reply
Re: [klangan] SELECT Word_ID like 'someword' problem In reply to
actually, I discovered that someword% doesn't work, but passing in substring=1 does.
I thought that was what the ww=0 was for.

peace.