Array data type, split string,

by

MySQL does not include a function to split a delimited string. However, it’s very easy to create your own function.

CREATE FUNCTION SPLIT_STR(
  x VARCHAR(255),
  delim VARCHAR(12),
  pos INT
)
RETURNS VARCHAR(255)
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
       LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),
       delim, '');

Usage

SELECT SPLIT_STR(string, delimiter, position)

From here:
http://blog.fedecarg.com/2009/02/22/mysql-split-string-function/

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. What is the error “Every derived table must have its own alias” in MySQL?
  3. Generating Depth based tree from Hierarchical Data in MySQL (no CTEs)
  4. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  5. How to grant remote access permissions to mysql server for user?
  6. mySQL convert varchar to date
  7. Generating a series of dates [duplicate]
  8. How to escape single quotes in MySQL
  9. MySQL comparison with null value
  10. Why is the estimated rows count very different in phpmyadmin results?
  11. Slow query when using ORDER BY
  12. How to import XML file into MySQL database table using XML_LOAD(); function
  13. Unique constraint that allows empty values in MySQL
  14. Matching all values in IN clause
  15. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  16. mysql field name from variable
  17. Multiple select statements in Single query
  18. How can I set a maximum number of rows in MySQL table?
  19. How to alter a column and change the default value?
  20. Which is faster — INSTR or LIKE?
  21. Remove duplicate rows leaving oldest row Only?
  22. Show constraints on tables command
  23. Remove special characters from a database field
  24. How big can a MySQL database get before performance starts to degrade
  25. Set user variable from result of query
  26. Mysql command not found in OS X 10.7
  27. Reset MySQL root password using ALTER USER statement after install on Mac
  28. MySQL: Insert datetime into other datetime field
  29. Selecting distinct 2 columns combination in mysql
  30. Import CSV to Update rows in table

Leave a Comment