当我们将 INSTR() 函数与 MySQL WHERE 子句一起使用时，我们需要提供表的列名作为第一个参数，提供子字符串作为第二个参数以及比较运算符。以下是使用“学生”表进行演示的示例 -

示例

假设“学生”表中有以下值 -

mysql> Select * from Student;+------+---------+---------+-----------+| Id   | Name    | Address | Subject   |+------+---------+---------+-----------+| 1    | Gaurav  | Delhi   | Computers || 2    | Aarav   | Mumbai  | History   || 15   | Harshit | Delhi   | Commerce  || 20   | Gaurav  | Jaipur  | Computers || 21   | Yashraj | NULL    | Math      |+------+---------+---------+-----------+5 rows in set (0.02 sec)

现在，以下查询展示了如何将 INSTR() 函数与 WHERE caluse 一起使用 -

mysql> select name, INSTR(Name,'av')As Result from student where INSTR(Name,'av')> 0;+--------+--------+| name   | Result |+--------+--------+| Gaurav |      5 || Aarav  |      4 || Gaurav |      5 |+--------+--------+3 rows in set (0.00 sec)mysql> select name, INSTR(Name,'av')As Result from student where INSTR(Name,'av') = 0 ;+---------+--------+| name    | Result |+---------+--------+| Harshit |      0 || Yashraj |      0 |+---------+--------+2 rows in set (0.01 sec)