SQL query construction - separate data in a column into two columns

Posted by Tommy on Stack Overflow See other posts from Stack Overflow or by Tommy
Published on 2010-03-26T15:31:56Z Indexed on 2010/03/26 15:43 UTC
Read the original article Hit count: 163

Filed under:
|

I have a column that contains links. The problem is that the titles of the links are in the same column, so it looks like this:
linktitle|-|linkurl
I want link title and linkurl in separate columns. I've created a new column for the urls, so I'm looking for a way to extract them and update the linkurl column with them. Is there any clever way to construct a query that does this?

© Stack Overflow or respective owner

Related posts about mysql

Related posts about query