Archive for the ‘MySQL’ Category

How to Find & Replace String in MySQL

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

PHP Object Relational Mapping (ORM) Tools List

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 […]

Mysql Left Join in Three tables

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 […]

Copyright © Sunware Technologies - Your web partner