Separating Fields

liro0917 · #1 (**permalink**) 04-05-10, 10:08

I have a database that I need to get information from. However, one of the fields have been used for what should just be a product name,but it has, Product Name, Size, Strength I need each of these fields to be separate field. How can I extract the data with a SQL query with each field becoming it's own they are separated by a space. Is it possible? Any ideas? I am using MYSql to query the data

Thanks!
Liro

r937 · #2 (**permalink**) 04-05-10, 10:34

separated by spaces? that's easy

Code:

SELECT SUBSTRING_INDEX(field,' ',1) AS product_name
     , SUBSTRING_INDEX(SUBSTRING_INDEX(field,' ',2),' ',-1) AS size
     , SUBSTRING_INDEX(SUBSTRING_INDEX(field,' ',3),' ',-1) AS strength
  FROM ...