I am using MySQL. I have a table called entries. This table has a column called body. The body column has string data (about 500 words long).
Now, I want transfer above body column into column_1,column_2,.... column_300 which contains nth word in each body column. So, if body column has a data like "I ate a lunch today", then column_1 would have 'I' , column_2 would have 'ate', and so on. I guess I can work this in PHP, but I have been wondering if it is possible in query in MySQL.
