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.
Comments
Post a Comment