php - Is there any query that can do database modification from one column to multiple columns? -


i using mysql. have table called entries. table has column called body. body column has string data (about 500 words long).

now, want transfer above body column column_1,column_2,.... column_300 contains nth word in each body column. so, if body column has data "i ate lunch today", column_1 have 'i' , column_2 have 'ate', , on. guess can work in php, have been wondering if possible in query in mysql.

see: split value 1 field two


Comments

Popular posts from this blog

objective c - Change font of selected text in UITextView -

php - Accessing POST data in Facebook cavas app -

c# - Getting control value when switching a view as part of a multiview -