--source include/have_innodb.inc CREATE TABLE t6 (a char(2) not null primary key, b varchar(20) not null, key (b)) engine=innodb; CREATE TABLE t7 (a char(2) not null primary key, b varchar(20) not null, key (b)) engine=innodb; INSERT INTO t6 values ('AB','MySQLAB'),('JA','Sun Microsystems'),('MS','Microsoft'),('IB','IBM- Inc.'),('GO','Google Inc.'); INSERT INTO t7 values ('AB','Sweden'),('JA','USA'),('MS','United States of Amercica'),('IB','North America'),('GO','South America'); update t6,t7 set t6.a=LCASE(t6.a); select * from t6; update t6,t7 set t6.a=UCASE(t6.a) where t6.a='AB'; select * from t6; update t6,t7 set t6.b=UPPER(t6.b) where t6.b LIKE 'United%'; select * from t7; update t6,t7 set t6.b=UPPER(t6.b),t7.b=LOWER(t7.b) where LENGTH(t6.b) between 3 and 5 and t7.a=LOWER(t6.a); select * from t6; select * from t7; drop table t6,t7;