another sql operation question - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

another sql operation question

another sql operation question# Database - 数据库

c*o2010-02-11 08:02

1 楼

have a huge dataset. dumped for 7 hours. unfortunatley, had a small mistake.
here is the problem.
col_1 is a string and col_2 is also a string but very similar to col_1. The
only difference is that col_2 has one or two more charactors than col_1. I
only need to keep the last one or two charators of col_2. How do I do it?
Here is an example:
I now have:
col_1 col_2
1string 1string1
2string 2string23
what I want:
col_1 col_2
1string

c*o2010-02-11 08:02

2 楼

got this figured out myself. this is an easy one.
update tbl_a
set col_2 = (select replace(col_2, col_1, ''));

mistake.
The

【在 c*******o 的大作中提到】

: have a huge dataset. dumped for 7 hours. unfortunatley, had a small mistake.
: here is the problem.
: col_1 is a string and col_2 is also a string but very similar to col_1. The
: only difference is that col_2 has one or two more charactors than col_1. I
: only need to keep the last one or two charators of col_2. How do I do it?
: Here is an example:
: I now have:
: col_1 col_2
: 1string 1string1
: 2string 2string23