To find a string in a certain field and replace it with another string: update [table_name] set [field_name] = replace([field_name],’[string_to_find]‘,’[string_to_replace]‘); like update user set name = replace(name,’Dr.’,’Mr.’); If you like the post & want to get more then Subscribe our blog posts. Subscribe SunwareTech.net RSS Feed • Facebook • Twitter • Email
Archive for the ‘MySQL’ Category
Posted in 
PHP Object Relational Mapping (ORM) Tools List
March 30th, 2011 
admin Object Relational Mapping (ORM) allows manipulation and control of data within a database as though it was a PHP object. Once you define the relationships ORM allows you to pull data from your database, manipulate the data in any way you like and then save the result back to the database without the use of [...]
Tags: Mysql Left Join in Three tables
March 15th, 2011 admin Lets assume we have to fetch data from three table a users (PK user_id) b departments c user_details department & user_details table have users department & user detailed information respectively & inter related with user_id select a.id, b.dept, c.project from users a left join departments b on a.user_id = b.user_id left join user_details c on [...]
