Richard Holland wrote:
Can you check the generated SQL to see if it is actually getting through?
Hi Richard,
I hacked it and made the names different (to print me the query again)
and the like is wrong:
(UNIPROT__DESCRIPTION__dm.text_1054 like 'Cytochrome')
Where it should be like
Ok, thanks for that. It confirms my suspicions!
BioMart currently relies on the MySQL-specific quirk that when using
'like', MySQL implicitly adds % symbols to both ends of the
expression, guessing that is what the user wanted. It only skips doing
this if a % is explicitly included in the search
Hi Renato,
why dont you try to specify '%' in your input to filter. e.g %cytochrome
%
syed
On Tue, 2008-07-01 at 16:10 +0100, Renato Golin wrote:
Richard Holland wrote:
Can you check the generated SQL to see if it is actually getting through?
Hi Richard,
I hacked it and made the
Syed Haider wrote:
Hi Renato,
why dont you try to specify '%' in your input to filter. e.g %cytochrome
%
Hi Syed,
Yes, that sure work.
Personally I think it'd be good to give the user that flexibility,
especially because you can say Citocrome% instead of wrapping with
both when you just