I think 'LIKE' is a good operator rather than inventing a new one,
because you can use '=' to indicate an exact match.
Will
On 19 Sep 2008, at 21:40, Richard Holland wrote:
Could have been performance related. In which case, why not define a
new filter type, 'contains', or something like that?
2008/9/19 Damian Smedley <[EMAIL PROTECTED]>:
On Fri, 19 Sep 2008, Syed Haider wrote:
Hi Richard,
I am afraid, there no such option unless you want to hack the sql
compiler :)
I came across the same thing recently. Maybe it would be good to have
something in the SQL compiler to automatically add %'s if the
operator is
LIKE (or whatever postgres and ORACLE). I seem to remember there
was a
reason we did not do this originally though
cheers
syed
On Fri, 2008-09-19 at 15:47 +0100, Richard Holland wrote:
Hello.
When I make a 'like' filter, I have to type '%' signs into the
filter
value to indicate the position of the wildcards.
Is there any type of filter I can use where it internally
automatically adds '%' to both ends of the filter value before
searching?
In other words, I'd like to have a filter on the page where I can
just
type a word and it will return me all records containing that word,
not just equal to it.
cheers,
Richard
--
Richard Holland, BSc MBCS
Finance Director, Eagle Genomics Ltd
M: +44 7500 438846 | E: [EMAIL PROTECTED]
http://www.eaglegenomics.com/
---
William Spooner
Visiting Scientist
[EMAIL PROTECTED]
