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 : 201
Tagged in : Mysql
Send mail vote down 0 vote down 0
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 .


 
PHPApacheFirefox TweeksShortcutsOthersCSSJavascriptDNSWindowsWebsitesLinuxGame programmingMS OfficeMysqlCVSHTMLJSP/JavaVPS (Virtual Private Server)AJAXFTP ServerFlashAdobe PhotoshopApple MacASPTally tweeksInteresting FactsSEOMailLyricsTomcatCalculationJokesPhilosophyRelax and EnjoyCShell ScriptingCareer OpportunitiesMusic/SongsPoemgoogleArtPerlInternet ExplorerDOMEnglishMechanicalHealthC++Outlook ExpressScience
It may be his last wish, before committing this suicide[marriage] :)
Sari Mokka.... thaanga mudiyala.. this video s created to spoil the fame of ilaya thalapathy..
Irritating idoit.. Divorce him immediately if you want a happy life.. I hate woman crying.. Might have given back the same to him at that moment itself...
nice story...
kadhalil sodhappuvadhu30 waysgoogle improveshow to30 ways
search creating aanjali anjalibackground colourcheck whether
Website Uptime Contact Us || Privacy Policy || Terms and Conditions

Web hosting by Hiox India 		rss