Collections:
INSTR() - Find Substring
How to find a substring in a given string using the INSTR() function?
✍: FYIcenter.com
INSTR(str, substr) is a MySQL built-in function that locates a substring in a string and replace it with a new string. For example:
SET @str = 'dba.FYIcenter.com'; SELECT INSTR(@str, 'FYI'); -- +--------------------+ -- | INSTR(@str, 'FYI') | -- +--------------------+ -- | 5 | -- +--------------------+
Reference information of the INSTR() function:
INSTR(str, substr): pos Returns the position of the first occurrence of substring substr in string str. This is the same as the two-argument form of LOCATE(), except that the order of the arguments is reversed. Arguments, return value and availability: str: Required. The string that will be searched in. substr: Required. The substring to search for. pos: Return value. The position where is substring is located. Available since MySQL 4.0.
Related MySQL functions:
⇒ LCASE() - Synonym for LOWER()
⇐ INSERT() - Insert and Replace Substring
2023-11-12, 213🔥, 0💬
Popular Posts:
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...