split_part

Description

Syntax

‘VARCHAR split party (VARCHAR content, VARCHAR delimiter, INT field)’

Returns the specified partition (counting from the beginning) by splitting the string according to the partitioner.

example

  1. mysql> select split_part("hello world", " ", 1);
  2. +----------------------------------+
  3. (hello world','1)'124split part';
  4. +----------------------------------+
  5. | hello                            |
  6. +----------------------------------+
  9. mysql> select split_part("hello world", " ", 2);
  10. +----------------------------------+
  11. (hello world','2)'124u;
  12. +----------------------------------+
  13. | world                             |
  14. +----------------------------------+
  16. mysql> select split_part("2019年7月8号", "月", 1);
  17. +-----------------------------------------+
  18. (2019726376;821495;','263761,') 1244;
  19. +-----------------------------------------+
  20. | July 2019|
  21. +-----------------------------------------+
  23. mysql> select split_part("abca", "a", 1);
  24. +----------------------------+
  25. split part ('abca','a', 1)
  26. +----------------------------+
  27. |                            |
  28. +----------------------------+

keyword SPLIT_PART,SPLIT,PART