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, 218🔥, 0💬
Popular Posts:
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...