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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 不懂到底要EXTRACT啥,比如 TEXT 'I want to eat an big apple', 找apple就找 : apple吧,还要找什么?extract big apple?那不就是SUBSTRING的操作了么
|
|