Hi Ellen, this is not implemented in Biomart v0.8 - at least as yet. I suppose this planned for some future releases.
Syed On 13 December 2012 14:00, Ellen Schofield <[email protected]> wrote: > Hi all, > > Just wondered if somebody could confirm whether the LIKE qualifier in > filters is meant to work in 0.8rc6? I can get the SQL to show and it shows > using like, but there is no insertion of % signs (mysql) to make the like > actually work. It just does the equivalent of a direct = search. > > Again, I may be doing something wrong :-) > > Here is the same query with the LIKE qualifier and the = (default) > qualifier... > > SELECT main.type, main.primary_id, main.keyword FROM > dev_es__gdxbase_keyword_mart.study__keyword__main main WHERE (main.keyword > LIKE 'ptpn22' ) > > SELECT main.type, main.primary_id, main.keyword FROM > dev_es__gdxbase_keyword_mart.study__keyword__main main WHERE (main.keyword > = 'ptpn22' ) > > > Any suggestions welcome, thank you, > > Ellen. > > -- > [email protected] > JDRF/WT Diabetes and Inflammation Laboratory (DIL) > Cambridge Institute for Medical Research (CIMR) > Wellcome Trust/MRC Building > Addenbrooke's Hospital Hills Road Cambridge CB2 0XY > Tel: 01223 763215 > > > _______________________________________________ > Users mailing list > [email protected] > https://lists.biomart.org/mailman/listinfo/users > _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
