试图进行查询,如果给定列包含的任何位置中的文本,将返回匹配。举例来说,如果我是通过单词真正包含文本的列这是一个很长的文本行将匹配。到目前为止,我查询仅返回是否完全匹配,因此将只匹配包含一列真,就是这样。
我已经尝试了几种方法,但似乎都返回相同的结果:
第一种方式(S为字符串,我传递):
光标光标= mDb.query(DATABASE_TABLE,新的String [] {} KEY_TITLE,KEY_TITLE +LIKE'%+ S +%'COLLATE NOCASE,NULL,NULL, NULL,NULL);
下一页方式
字符串p_query =SELECT COUNT(*)FROM数据WHERE数= COLLATE NOCASE?
解决方案
试图进行查询,如果给定列包含的任何位置中的文本,将返回匹配。
这对我的作品,它的参数:
光标光标= mDb.query(DATABASE_TABLE,新的String [] {} KEY_TITLE, KEY_TITLE +怎么样?,新的String [] {%+ S +%}, NULL,NULL,NULL);
真的是一个独特的足够的词,但如果你正在寻找的东西,如冰,不想骰子,风云,冰淇淋,等你将不得不使用不同的模式,如:%+ S +%
和 S +%
或者使用FTS表与标记生成器,像波特词干。
Trying to make a query that will return a match if the given column contains the text anywhere inside. For instance if I were to pass the word "really" a column containing the text "This is a really long line of text" would match. So far my queries only return if it matches exactly so it would only match a column containing "really" and that is it.
I've tried a couple ways but both seem to return the same result:
First way (s is the string I'm passing in):
Cursor cursor = mDb.query(DATABASE_TABLE, new String[] {KEY_TITLE}, KEY_TITLE + " LIKE '%" + s + "%' COLLATE NOCASE", null, null, null, null);
Next way
String p_query = "SELECT COUNT(*) FROM data WHERE number=? COLLATE NOCASE";
解决方案
Trying to make a query that will return a match if the given column contains the text anywhere inside.
This works for me and it's parameterized:
Cursor cursor = mDb.query(DATABASE_TABLE, new String[] {KEY_TITLE},
KEY_TITLE + " LIKE ?", new String[] {"%" + s + "%"},
null, null, null);
"Really" is a distinct enough word, but if you are searching for something like "ice" and don't want "dice", "vice", "icecream", etc you'll have to use different patterns like: "% " + s + " %"
and s + " %"
.
Or use an FTS table with a tokenizer, like Porter Stemming.