The SUBSTRING_INDEX function in MySQL is used to extract a substring from a given string. It returns the part of the string before or after a specified delimiter.
Syntax:
SUBSTRING_INDEX(string,delimiter,count)
Parameters:
- string: The original string from which you want to extract a substring.
- delimiter: The character or string that separates the parts of the string.
- count: An integer value that determines how many times the delimiter appears in the string.
Example:
SELECT SUBSTRING_INDEX(‘www.example.com’, ‘.’, 2)
Output:
www.example
![pyScript="${HOME_DIR}/workspace_liu/bootstrap/bootstrap_loader.py"
COM=$1
burnVersion=$2
if [[ $# < 3 ]]; then
IPAddr="192.168.1.200"
else
IPAddr=$3
fi
binaryFiles="${HOME_DIR}/workspace_liu/bootstrap"](https://linuxcpp.0voice.com/zb_users/upload/2023/05/202305162233193420680.png)
