CREATE DATABASE `test`;
USE `test`;
/*Table structure for table `memberdetails` */
DROP TABLE IF EXISTS `memberdetails`;
CREATE TABLE `memberdetails` (
`id` int unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
`street` varchar(20) DEFAULT NULL,
`city` varchar(20) DEFAULT NULL,
PRIMARY KEY (`id`)
) ;
/*Data for the table `memberdetails` */
insert into `memberdetails`(`id`,`name`,`street`,`city`)
values (1,'Fred','Old Street','Bedrock')
,(2,'Barney','Old Street','Bedrock')
,(3,'Slate','Other Street','Bedrock');
SELECT * from memberdetails;
+----+--------+--------------+---------+
| id | name | street | city |
+----+--------+--------------+---------+
| 1 | Fred | Old Street | Bedrock |
| 2 | Barney | Old Street | Bedrock |
| 3 | Slate | Other Street | Bedrock |
+----+--------+--------------+---------+
3 rows in set (0.00 sec)
UPDATE `memberdetails`
SET street='New Street'
WHERE street='Old Street' AND city='Bedrock';
SELECT * from memberdetails;
+----+--------+--------------+---------+
| id | name | street | city |
+----+--------+--------------+---------+
| 1 | Fred | New Street | Bedrock |
| 2 | Barney | New Street | Bedrock |
| 3 | Slate | Other Street | Bedrock |
+----+--------+--------------+---------+
3 rows in set (0.02 sec)
Works for me.
Show us your tables and data.
Good luck,
Barry.