Mysql string truncation command _ MySQL

Mysql string truncation command bitsCN.com

Mysql string truncation command

1. substring_index

Substring_index (str, delim, count)

[Html]

Mysql> select substring_index ('A-B-c-D', '-',-1 );

+ ----------------------------------- +

| Substring_index ('A-B-c-D', '-',-1) |

+ ----------------------------------- +

| D |

+ ----------------------------------- +

1 row in set (0.00 sec)

Mysql> select substring_index ('A-B-c-D', '-', 1 );

+ ---------------------------------- +

| Substring_index ('A-B-c-D', '-', 1) |

+ ---------------------------------- +

| A |

+ ---------------------------------- +

1 row in set (0.00 sec)

2. SUBSTRING

SUBSTRING (str, pos, len)

SUBSTRING (str FROM pos FOR len)

SUBSTRING (str, pos)

SUBSTRING (str FROM pos)

[Html]

Mysql> select substring (substring_index ('A-B-c-D', '-', 2), 2 );

+ ------------------------------------------------- +

| Substring (substring_index ('A-B-c-D', '-', 2), 2) |

+ ------------------------------------------------- +

|-B |

+ ------------------------------------------------- +

1 row in set (0.01 sec)

BitsCN.com