sql语句中的文本检索

想要对数据库中的表中某个字段的文本进行关键字检索，可以使用CONTAINS字段

Contains语法
select * from table_name where contains( fulltext_column, 'search contents')
例如：
select * from student where Contains(address, 'hebei') ---->单词使用单引号
select * from student where Contains(address, '"HEBEI province"') --->词组单引号中还要有双引号
select * from student where contains(address, '"hebeisheng province" OR beijing') 可以指定逻辑操作符AND, AND NOT
select * from student where contains(address, 'nanjing NEAR road')查询将返回nanjing road, nanjing east road, nanjing west road等，A NEAR B  表示  A靠近B 　
查询以hu开头的地址
select * from student where contains(address, '"hu*"')

转载于:https://www.cnblogs.com/smartmanlog/p/10790513.html