Fastest Web Hosting

replace specific word from mysql column

0 votes
asked Aug 2, 2016 in Mysql by Manoj Insan (1,600 points)

Please share sql query which can be replace specific word from entire column data..actually i have a column in mysql tabel where url is placing . i want to replace all url which are start from http:// with https://

2 Answers

0 votes
answered Aug 2, 2016 by yuri (180 points)
SELECT column,  
REPLACE(column,'http://','https://')   
FROM table
commented Aug 3, 2016 by Manoj Insan (1,600 points)
thanks for provide solution..it's working for me
0 votes
answered Sep 2, 2016 by rohit (2,750 points)

If you want to update permanently in table column use below query

UPDATE table_name SET col_name= REPLACE(col_name, 'remove_this_word ', 'place_this_word');

Job Board

TechnicalSharp is a technical community of developers where they are sharing their knowledge and solutions and against it they are getting the score point which help them to make profile strong which is under eyes on MNC's
...