<div>
Hi!<br />
<br />
WOW, thanks so very match...<br />
<br />
Works very good...
</div>


Hi!

WOW, thanks so very match...

Works very good...

<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
Have a table in mysql that contains of a field (navn) like:<br />
Arne Hansen<br />
Per Iversen<br />
Ole Berg<br />
..<br />
..<br />
<br />
What i want is to copy Hansen,Iversen and Berg to a new field(etternavn)<br />
And remove Hansen,Iversen and Berg from navn field..<br />
<br />
How can i do this...<br />
<br />
I can olso do this from visual studio 2008, if this is not possible with a query.<br />
<br />
<br />

</div>
</div>


Hi!

Have a table in mysql that contains of a field (navn) like:
Arne Hansen
Per Iversen
Ole Berg
..
..

What i want is to copy Hansen,Iversen and Berg to a new field(etternavn)
And remove Hansen,Iversen and Berg from navn field..

How can i do this...

I can olso do this from visual studio 2008, if this is not possible with a query.




Make query that remove characters, and copy removed characters to a new field

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.