InStr function String position search in MySQL

Usage:

INSTR (Ori_str, SUB_STR)

MySQL INSTR () finds the position of a string in another string, returning the index value of the first occurrence.

Example:
1.

The code is as follows	Copy Code
Mysql> Select InStr (' Www.111cn.net ', '. '); + —————————-+ | InStr (' Www.111cn.net ', '. ') | + —————————-+ | 4 | + —————————-+ 1 row in Set

2. can replace link use

code is as follows	copy code
SELECT * From table WHERE 1 = InStr (' title ', ' Phpff '); Equivalent to SELECT * from table WHERE ' title ' Like '%phpff% ';