b******t
发帖数: 10 | 1 I got a table which has a longtext field, one record of this field has
probably 2000 words, I want to get some text from this field, this can be
done by searching the whole record for certain key words to locate them,
then make the text I get a new field, How to do it?
mysql
about 6000 rows | s**********o
发帖数: 14359 | | b******t
发帖数: 10 | 3 Thanks, but I assume fulltext index can return records which match the
keywords, I don't want that, I want to extract certain text from a field,
can fulltext search do that? | S********p
发帖数: 168 | 4 http://stackoverflow.com/questions/840138/sql-query-to-extract-
【在 b******t 的大作中提到】
: I got a table which has a longtext field, one record of this field has
: probably 2000 words, I want to get some text from this field, this can be
: done by searching the whole record for certain key words to locate them,
: then make the text I get a new field, How to do it?
: mysql
: about 6000 rows
| s**********o
发帖数: 14359 | 5 不懂到底要EXTRACT啥，比如 TEXT 'I want to eat an big apple', 找apple就找
apple吧，还要找什么？extract big apple?那不就是SUBSTRING的操作了么 | b******t
发帖数: 10 | | b******t
发帖数: 10 | 7 我要extract譬如I和apple之间的所有字符，刚才看了上面的link,好像可以charindex
非常谢谢你
【在 s**********o 的大作中提到】
: 不懂到底要EXTRACT啥，比如 TEXT 'I want to eat an big apple', 找apple就找
: apple吧，还要找什么？extract big apple?那不就是SUBSTRING的操作了么
|
|
