Can MySQL split a column?

by

Use 

substring_index(`column`,',',1) ==> first value
substring_index(substring_index(`column`,',',-2),',',1)=> second value
substring_index(substring_index(`column`,',',-1),',',1)=> third value

in your where clause.

SELECT * FROM `table`
WHERE 
substring_index(`column`,',',1)<0 
AND
substring_index(`column`,',',1)>5

More Related Contents:

  1. Split value from one field to two
  2. How to split the name string in mysql?
  3. Mysql string split [duplicate]
  4. MySQL substring extraction using delimiter
  5. MYSQL – Split Data Into Multiple Rows
  6. NOT LIKE not working with SHOW [duplicate]
  7. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  8. Joining three tables using MySQL
  9. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  10. MySQL Orderby a number, Nulls last
  11. Troubleshooting “Illegal mix of collations” error in mysql
  12. How should I store GUID in MySQL tables?
  13. How to perform a mysqldump without a password prompt?
  14. Select the 3 most recent records where the values of one column are distinct
  15. How to remove leading and trailing whitespace in a MySQL field?
  16. How to reset the root password in MySQL 8.0.11?
  17. How does MySQL CASE work?
  18. What characters have to be escaped to prevent (My)SQL injections?
  19. How to save MySQL query output to excel or .txt file? [duplicate]
  20. MySQL: Set user variable from result of query
  21. Is there any performance gain in indexing a boolean field?
  22. NodeJS responded MySQL timezone is different when I fetch directly from MySQL
  23. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ [duplicate]
  24. How to swap values of two rows in MySQL without violating unique constraint?
  25. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  26. Storing images in MySQL [closed]
  27. Would it help to add index to BIGINT column in MySQL?
  28. In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?
  29. MySQL – How to parse a string value to DATETIME format inside an INSERT statement?
  30. MySQL Multiple Joins in one query?

Leave a Comment