你即將離開本站

並前往https://help.looker.com/hc/en-us/articles/360024266693-Splitting-Strings-into-Rows-in-the-Absence-of-Table-Generating-Functions

Splitting Strings into Rows in the Absence of Table-Generating ...

For MySQL, you could use SUBSTRING_INDEX instead of split_part : SELECT DISTINCT SUBSTRING_INDEX(SUBSTRING_INDEX(vals, ',', n.digit+1), ',', -1) ...

確定！ 回上一頁

查詢 「MySQL split string」的人也找了：

  1. MySQL split field
    2.
  2. Mysql split
    3.
  3. MySQL split string to array
    4.
  4. MySQL explode
    5.
  5. MySQL split string to rows
    6.
  6. MySQL SUBSTRING_INDEX
    7.
  7. MySQL REPLACE
    8.
  8. MySQL string to array
    9.