Collections:
LOCATE() - Locate Substring Starting at N
How to locate a substring using the LOCATE() function?
✍: FYIcenter.com
LOCATE(substr, str, pos) is a MySQL built-in function that searches a substring in a string starting at a given position and returns the location of the substring. For example:
SET @str = 'Row, row, row your boat'; SELECT LOCATE('row', @str, 7); -- +------------------------+ -- | LOCATE('row', @str, 7) | -- +------------------------+ -- | 11 | -- +------------------------+
Reference information of the LOCATE() function:
LOCATE(substr, str, pos): location Returns the position of the first occurrence of substring substr in string str, starting at position pos. Returns 0 if substr is not in str. Returns NULL if any argument is NULL. Arguments, return value and availability: substr: Required. The substring to search for. str: Required. The string that will be searched in. pos: Optional. Default is 1. The position to start the search. location: Return value. The position where is substring is located. Available since MySQL 4.0.
Related MySQL functions:
⇒ LOWER() - Convert String to Lower Case
⇐ LENGTH() - Number of Bytes in String
2023-11-12, 221🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...