Can you split/explode a field in a MySQL query?

by

Until now, I wanted to keep those comma separated lists in my SQL db – well aware of all warnings!

I kept thinking that they have benefits over lookup tables (which provide a way to a normalized data base). After some days of refusing, I’ve seen the light:

  • Using lookup tables is NOT causing more code than those ugly string operations when using comma separated values in one field.
  • The lookup table allows for native number formats and is thus NOT bigger than those csv fields. It is SMALLER though.
  • The involved string operations are slim in high level language code (SQL and PHP), but expensive compared to using arrays of integers.
  • Databases are not meant to be human readable, and it is mostly stupid to try to stick to structures due to their readability / direct editability, as I did.

In short, there is a reason why there is no native SPLIT() function in MySQL.

More Related Contents:

  1. INSERT INTO SELECT statement with more columns which is not in another table
  2. Access denied for user ‘root@localhost’ (using password:NO)
  3. Column calculated from another column?
  4. Error in MySQL when setting default value for DATE or DATETIME
  5. How to recover MySQL database from .myd, .myi, .frm files
  6. How do I do a fuzzy match of company names in MYSQL with PHP for auto-complete?
  7. how to compute similarity between two strings in MYSQL
  8. Timestamp with a millisecond precision: How to save them in MySQL
  9. Duplicating a MySQL table, indices, and data
  10. sql join two table
  11. How to schedule a MySQL query?
  12. Cast int to varchar
  13. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  14. Import SQL file into mysql
  15. How to export data from SQL Server 2005 to MySQL [closed]
  16. MySQL SELECT last few days?
  17. “where 1=1” statement [duplicate]
  18. How do you debug MySQL stored procedures?
  19. MySQL Calculate Percentage
  20. ld: library not found for -lzstd while bundle install for mysql2 gem Ruby on macOS Big Sur 11.4 Apple M1
  21. mysql select sum group by date
  22. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  23. My SQL Dynamic query execute and get ouput into a variable in stored procedure
  24. Postgres LEFT JOIN with WHERE condition
  25. MySQL – Using COUNT(*) in the WHERE clause
  26. MySQL Integer vs DateTime index
  27. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  28. How to initialize mysql container when created on Kubernetes?
  29. Find duplicates in the same table in MySQL
  30. Auto-increment is not resetting in MySQL

Leave a Comment