how to update my url column in sql which has & in string

Question

update <table> set url="http://www.google.com?a=1&something=so"

If I'm updating directly my string is updated till ?a=1 from & it is eliminating. can any one help me in this if my url contains any special symbol and how I need to update. I'm working from java

possible duplicate of [Best way to escape strings for sql inserts?](http://stackoverflow.com/questions/633109/best-way-to-escape-strings-for-sql-inserts) — jny, May 21 '15 at 16:05

Pshemo · Answer 1 · 2015-05-21T16:14:36.223

To avoid problems with string values consider using PreparedStatement and its setString method which will generate proper query with escaped values (if needed).

So try with

PreparedStatement ps = con.prepareStatement("update table set url=?");
//           +----------------------------------------------------^
//           | represents where we should put value
ps.setString(1, "http://www.google.com?a=1&something=so");

//then execute this statement

score 0 · Answer 2 · answered May 21 '15 at 16:29

use this:-

update [table_name] set url='http://www.google.com?a=1'||'&'||'something=so'

here we are concatenating &, so that it does not create problem while update.

FYI.. if we have & in the string we try to update, oracle consider string following & as a parameter whose value it thinks as if it will be provided at run time, that is the reason why it was troubling you.

how to update my url column in sql which has & in string

2 Answers2