Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
[SQLS]-Split and update a column
create table t (a varchar(32)); insert into t (a) values ('adridi_amaris.com'); insert into t (a) values ('jmoretti_amaris.com'); select * from t update t set a = left(a, charindex('_',a+'_')-1) ; select * from t;
run
|
edit
|
history
|
help
0
New
kirthi
TABLE
Lab 4
repert
FOREIGN KEY
1D Hotel
Group by
persons
new