{"id":4702,"date":"2013-12-17T19:25:39","date_gmt":"2013-12-18T03:25:39","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=4702"},"modified":"2023-10-12T21:58:34","modified_gmt":"2023-10-13T04:58:34","slug":"mysql-instr","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-string-functions\/mysql-instr\/","title":{"rendered":"MySQL INSTR() Function"},"content":{"rendered":"\n

Summary<\/strong>: This tutorial shows you how to use the MySQL INSTR()<\/code> function to return the position of the first occurrence of a string.<\/p>\n\n\n\n

Introduction to the MySQL INSTR() function<\/h2>\n\n\n\n

Sometimes, you want to locate a substring in a string or to check if a substring exists in a string. In this case, you can use a string built-in function called INSTR<\/code>.<\/p>\n\n\n\n

The INSTR<\/code> function returns the position of the first occurrence of a substring in a string. If the substring is not found in the str, the INSTR<\/code> function returns zero (0).<\/p>\n\n\n\n

The following illustrates the syntax of the INSTR<\/code> function.<\/p>\n\n\n

INSTR(str,substr);<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Try It Out<\/a><\/p>\n\n\n\n
The INSTR<\/code> function accepts two arguments:<\/p>\n\n\n\n