mySQL: Return text between delimiters in MySQL - Returns the text between the specified delimiters in MySQL.

Quick Search:

mySQL: Return text between delimiters in MySQL

Jump to:

Snippet Name: Return text between delimiters in MySQL

Description: Returns the text between the specified delimiters in MySQL.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

SELECT 
  SUBSTR(COLUMN, 
    LOCATE(':',COLUMN)+1, 
      (CHAR_LENGTH(COLUMN) - LOCATE(':',REVERSE(COLUMN)) - LOCATE(':',COLUMN))) 
FROM TABLE