本文介绍了SQL查询从列中提取文本并将其存储到同一记录中的其他列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要一些SQL查询的帮助...
I need some help with a SQL query...
我有一个SQL表,它保存在已提交表单的列的详细信息。我需要获取存储在该列中的文本的一部分,并将其放在同一行的不同列中。
I have a SQL table that holds in a column details of a form that has been submitted. I need to get a part of the text that is stored in that column and put it into a different column on the same row. The bit of text that I need to copy is always in the same position in the column.
任何帮助都会感激的家伙...我的想法已经空白: >
Any help would be appreciated guys... my mind has gone blank :">
推荐答案UPDATE mytable SET other_column = SUBSTRING(column, begin_position, length)
更多推荐
SQL查询从列中提取文本并将其存储到同一记录中的其他列
发布评论