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
