var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Select Query
I am using the select query as below
Select country from table1 which give the output as
I want to change whenever US comes it change to USA. So the output should be as below-:
Originally Posted by goodman2253
or as alternative, execute the following query once and you don't have to worry about what the Select statement returns.
Select Case when country = 'US' then 'USA' else country end
Note: None of this code is tested. Please test before using.
Update Table1 SET
Country = 'USA'
Where Country = 'US'
any function like regexp_replace. Because using case make the sql query execute very slow. For one case its fine, but If I have to use multiple then. I hope you understand my point
Is it true? I doubt that.
... using case make the sql query execute very slow. ...
From where did you go the information?
Another point might be that the CASE expressin provided by LinksUp was not multiple cases.
... For one case its fine, but If I have to use multiple then.
The CASE expressin contains only one case.
Last edited by tonkuma; 09-08-13 at 15:21.