CODEWITHSUNDEEP
sqlsql-update
user2829026
user2829026

Reputation: 147

How can I add text to SQL Column

I want to update 1 column in SQL Table. Example: Current value in column is like this

2013/09/pizzalover.jpg 
2013/10/pasta.jpg

Now i want to update whole column like this : www.mypizza.com/2013/09/pizzalover.jpg Is there any way I can accomplish this? Thanks in advance

Upvotes: 14

Views: 107075

Answers (6)

ORHAN YILMAZ
ORHAN YILMAZ

Reputation: 21

If you use SQlite3, you may|| oparator.

For Ex:

update Diodes set KICAD_SCHLIB = "ORELTEK_lib:" || "Library Ref" where "Library Ref" not in  ("Resistor" ,"Capacitor", "ELEC_Capacitor", "Inductance", "Feridbeed", "STD_Diode", "Schottky_Diode", "LED", "TVS_Diode", "Zener_Diode")

Upvotes: 1

Lucio Mollinedo
Lucio Mollinedo

Reputation: 2424

OP doesn't specify which DBMS they are using. The following is for Postgres to update a text column by adding a prefix to it (tested with PostgreSQL v11):

UPDATE my_table 
SET column_1  = 'start_text_' || column_1
WHERE column_1 LIKE 'prefix_%'
;

Upvotes: 2

Jac Engels
Jac Engels

Reputation: 83

First get the information stored in your database and then edit it, you can do that like this:

<?php 
$query = "SELECT * FROM  `blog-posts`  WHERE `id` = 11";
$result = mysql_query($query);
$post = mysql_fetch_array($result);
$title = $post['title'];
$title .= "aapje";
echo $title
?>

And then update your database like normal:

$updateq = "UPDATE `blog-posts`  SET `title` = '$title' WHERE `id` = 11";

Upvotes: 1

heretolearn
heretolearn

Reputation: 6545

If you are using MYSql, you can use the concat() as :

update tableName set columnName= CONCAT('www.mypizza.com/', columnName);

SQLFiddle

If you are using oracle you can use the concatenation operator '||' as :

update tableName set "columnName"='www.mypizza.com/'||"columnName";

SQLFiddle

In SQL Server you can use + for string concatenation as:

update tableName set name='www.mypizza.com/'+columnName;

SQLFiddle

Upvotes: 13

Satpal
Satpal

Reputation: 133403

You can simply update column using statement

update TableName set ColumnName  = 'www.mypizza.com/' + ColumnName

Upvotes: 15

David
David

Reputation: 218818

You mean like this?:

SELECT 'www.mypizza.com/' + ColumnName AS ColumnName FROM TableName

Depending on the rest of your application environment, there is likely a much better way to accomplish this. But in terms of just using SQL to add static text to a column in a SELECT statement, you can just concatenate the text directly in the statement.

Or, if you wanted to UPDATE the column values, something like this:

UPDATE TableName SET ColumnName = 'www.mypizza.com/' + ColumnName

Same principle, just using an UPDATE instead of a SELECT, which will modify the underlying data instead of just modifying the view of the data.

Upvotes: 2

Related Questions