View Scraps
Today in History
Celebrity Birthdays
Celebrity Deaths
Thoughts
Sign Up
Sign In
Welcome Guest
Submit Scraps
Most Viewed Scraps
Top Rated Scraps
search & replace string in mysql - Mysql Views : 216
Tagged in : Mysql
0 0
Send mail
search & replace string in mysql:

To find & replace string in mysql use "update" as,
update tablename set fieldname = replace(fieldname,'search string','replace with')


Example:
update test set description = replace(description,'”','"')


update clipart set description = replace(description,'”','"')

By Ramya, On - 2010-04-07


    Login to add Comments .


 
ApacheFirefox TweeksShortcutsPHPOthersCSSJavascriptDNSWindowsWebsitesLinuxGame programmingMysqlCVSHTMLMS OfficeJSP/JavaFTP ServerFlashAJAXVPS (Virtual Private Server)Adobe PhotoshopTally tweeksSEOInteresting FactsMailASPTomcatLyricsCalculationJokesShell ScriptingCCareer OpportunitiesRelax and EnjoyPhilosophyPoemArtPerlMusic/SongsInternet ExplorerEnglishgoogleC++Outlook ExpressDOMScienceWHM/cpanelNewsfun
nice
Good Guesses....
Its Leaf sorry
Stem - Strength Leave - Victory Fruits - Innovative
The stem shows strength, Red color shows unique. bud shows team work.
Energy of Stem, A small new bud means getting innovation.
the stem shows the strength of the company, leaf shows the unity and the fruits tell about the new comers that means new clients,domains,hosting etc
are you oxymoron? just a guess...
Thala Dhan Toppu. Thuppaki Doopppu (Dupe)
Here it is???
plesk apiphp mailgetting valueswhats specialcpanel var
how thethe reasonnew stylecousin victorfact of
Website Uptime Contact Us || Privacy Policy || Terms and Conditions

Web hosting by Hiox India 		rss