Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL like query and then update or replace
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Gaurav Singh
like query and then update or replace
2 Answer(s)      3 years and 9 months ago
Posted in : SQL


In postgres i use like query to find the a specific word in a column for example in a column i have text "Small state in wmost Brazil bordered by sw Amazonas, Peru, and Bolivia."

with like query i can find text that contains text "wmost" after finding that i want to replace or update "wmost" to "westernmost" in that text.

is there a way to do that?

Please need urgent help in this matter.

Best YJ


Advertisement
View Answers

April 1, 2011 at 4:21 PM


We have created a table message(id,data);

Use the following query:

update message set data = replace (data, 'wmost','westernmost');


April 4, 2011 at 5:04 PM


thanks a lot i could do it with this, but the only problem is if i want to change "nmost" to "northernmost" this query also changes "southernmost" to "southernothernmost". if you notice then "nmost" is common in other strings also. is there a way to avoid this problem. Can you send similar query using regexp_replace expression so that it only identifies "nmost" and not anyone of these: southernmost, easternmost, northernmost, westernmost.

Really appreciate your help.

Thanks YJ



Related Tutorials/Questions & Answers:
like query and then update or replace
like query and then update or replace   In postgres i use like query... to replace or update "wmost" to "westernmost" in that text. is there a way to do... "Small state in wmost Brazil bordered by sw Amazonas, Peru, and Bolivia." with like
regexp_replace in update and replace query in postgres
regexp_replace in update and replace query in postgres  update message set data = replace (data, 'wmost','westernmost'); April 4, 2011 at 5:04 PM.... is there a way to avoid this problem. Can you send similar query using regexp_replace
Advertisements
update query
update query  using oops concept in php.. How to update the data from databse ? with program example
Hibernate Like Query
This section illustrate hibernate like query with example
Replace
Replace   Hi, I have two text files in two diff locatons.The text file like below using java program 1)a.txt 1 abc bangalore 2 def adfsdf 3 ghij asdfdsad 2)b.txt A B C Now i want output is like below
Hibernate update Query
Hibernate update Query In this tutorial you will learn about an update query in Hibernate This tutorial is based on how to write HQl update query in hibernate. In hibernate update query updates the data of the database table when
Hibernate HQL query by using like operator.
Hibernate HQL query by using like operator.  How use like operator in HQL?   HQL stands for Hibernate Query Language, provided by Hibernate... from Employee emp WHERE emp.name like 'R%'"; Query query
ereg_replace() and eregi_replace().
ereg_replace() and eregi_replace().  What is the difference between eregreplace() and eregireplace()?   Hi friends, ereg_replace() is case sensitive like "Bharat"cannot be treated as "bharat"and eregi_replace
how do i use sql like query in my jsp page
how do i use sql like query in my jsp page  how do i use sql like query in my jsp page   Hi Friend, Try the following code: <%@ page... where name like 'a%'"); while(rs.next()){ out.println(rs.getString("name")+"<
Hibernate Update Query
Hibernate Update Query       In this tutorial we will show how to update a row with new information... write a java class to update a row to the database. Create a java class: Here
Replace TEXT
Replace TEXT   I have two text files in two diff locatons.The text file like below using java program 1)a.txt 1 abc bangalore 2 def adfsdf 3 ghij asdfdsad 2)b.txt A B C Now i want output is like below
MySQL Replace
update query on the table "mca". The REPLACE() function will replace...;. Query  UPDATE `mca` SET `subject` = REPLACE(`subject`,"... MySQL Replace      
update
update  how can i update multiple records in database using jsp ,servlet and jdbc based on selection of checkbox in jsp
update
update  Predict and justify the output of the following code snippet written by the developer to update the Status table: String str = "UPDATE m...://localhost:3306/roseindia", "root", "root"); String str = "UPDATE Status SET
HQL Update Statement to update database table
HQL Update Statement to update database table HQL's update query statement is used to update the values of database rows. Though HQL is similar to SQL... objects and their properties. Hibernate query language (HQL) also supports WHERE
What is the difference between ereg_replace() and eregi_replace()?
What is the difference between ereg_replace() and eregi_replace()?  What is the difference between eregreplace() and eregireplace
replace character in php
replace character in php  PHP script that replace character
find and replace in java
find and replace in java  Need 'find and replace' function in Java to find special keyword in XMl such as @,#,!,%..and replace with their corresponding entities
MySql find and replace string
MySql find and replace string  How to find and replace string or special characters in MySql & PHP?   Find and Replace String PHP $result = preg_replace('/\band\b/i', 'foo', $subject
Mysql Like Operator
Mysql Like Operator       Mysql Like is used to retrieve the records on the basis of pattern matching in select query. The like comparison Operator in SQL allows you to match any
Mysql Like Operator
Mysql Like Operator       Mysql Like is used to retrieve the records on the basis of pattern matching in select query. The like comparison Operator in SQL allows you
Mysql like syntax
Mysql like syntax       Mysql Like is used to retrieve the records on the basis of pattern matching in select query. The like comparison Operator in SQL allows you to match any
Mysql like syntax
Mysql like syntax       Mysql Like is used to retrieve the records on the basis of pattern matching in select query. The like comparison Operator in SQL allows you
PHP SQL LIKE Operator
; This example illustrates how to use the like operator in sql query.... $result = mysql_query("select * from emp where name like 's%'"); In the query...("select * from emp where name like '%h'"); In the query below, we want to find
Mysql Trigger after Update
an update query on table. Understand with Example The Tutorial understand...; delimiter ; Query to update employee table:- mysql> update employee set start_date='20061231'; Table that has been modified after update query executes
Difference between translate and replace
Difference between translate and replace   hiii, What is the difference between translate and replace?   hello, Replace replace every.... this work for entire word and pattern,. Translate replace the one charecte
String doubt replace function
String doubt replace function  What is the output and why of below : String s1 = "Hello"; if(s1.replace('H','H')== "Hello") System.out.println("yes"); else System.out.println("No"); if(s1.replace("H", "H")== "Hello
Replace String in PHP - PHP
Replace String in PHP  What is the fastest way of replacing string in PHP Code?  Hi Friend, Please visit the following link: http://www.roseindia.net/tutorial/php/phpbasics/PHP-Array-Replace.html Thanks
replace special characters in html
replace special characters in html  How can i replace the special characters in HTML?   Special Character in HTML HTML has a long list of special characters symbol that can be used anywhere throughout the HTML Code
PHP SQL LIKE Operator
in sql query. The LIKE operator is used in a WHERE clause to search... like 's%'"); In this query we want to find the name which end with h. $result = mysql_query("select * from emp where name like '%h
Replace JSF Standard Error Message
Replace JSF Standard Error Message  How can we replace the JSF Standard Error Message
Advertisements
 

 

 

DMCA.com