SqlServer建立全文索引
例如
SELECT student_id,student_name
FROM students
WHERE CONTAINS( address, 'beijing' )
Oracle的模糊查询(利用函数INSTR查询)
SELECT *
from "Area"
where "INSTR"("AreaNumber", '001')>0
SqlServer建立全文索引
例如
SELECT student_id,student_name
FROM students
WHERE CONTAINS( address, 'beijing' )
Oracle的模糊查询(利用函数INSTR查询)
SELECT *
from "Area"
where "INSTR"("AreaNumber", '001')>0