请教各位: 以text数据类型的字段为条件查询!

christine6280

请问: text类型的字段里已存放一个长串, 现在想以该串的部分内容作为条件查询出一条记录,可以实现吗??
谢谢

admin159

like '%ABC%'

IFMXDBA

that is not the proper way that text field supposed to be used. If you are trying do match operation, go for long varchar, char, or varchar not text/clob.  If you are talking about full text search, you may need text datablade to help you to do this job.  With text datablade, you can search if a string is contained in the clob type field.  A special index index on the clob type field will be created.