Oracle uses InStr or like methods to determine whether to include strings _oracle

The first thing that comes to mind is contains,contains usage as follows:

SELECT * from students where contains (address, ' Beijing ')

However, using the CONTAINS predicate has the condition that the column is indexed, that is, if the address column of the students table in the preceding statement does not have an index, an error is presented.

Fortunately, there is another way to use INSTR,INSTR:

SELECT * FROM students where InStr (address, ' Beijing ') > 0

In addition, there is a stupid way, that is to use like, said here everyone should know how to do it:

SELECT * from students where address like '%beijing% '