nesto si ga zakomplikovao ..
Code:
mysql> show create table t2\G
*************************** 1. row ***************************
Table: t2
Create Table: CREATE TABLE `t2` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`polje1` varchar(45) DEFAULT NULL,
`polje2` varchar(45) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)
mysql> select * from t2;
+----+--------+--------------------------------+
| id | polje1 | polje2 |
+----+--------+--------------------------------+
| 1 | (med.) | ovde pise ovaj izraz kukuriku |
| 2 | (med.) | ovde pise ovaj izraz kukuriku1 |
| 3 | (med.) | ovde pise ovaj izraz kukuriku2 |
| 4 | (med.) | ovde pise ovaj izraz kukuriku3 |
| 5 | aaa | ovde pise ovaj izraz kukuriku3 |
| 6 | aaa | ovde pise ovaj izraz kukuriku5 |
+----+--------+--------------------------------+
6 rows in set (0.00 sec)
mysql> select replace(polje2, 'ovaj izraz', 'ona fraza') from t2 WHERE polje1 LIKE '(med.)';
+--------------------------------------------+
| replace(polje2, 'ovaj izraz', 'ona fraza') |
+--------------------------------------------+
| ovde pise ona fraza kukuriku |
| ovde pise ona fraza kukuriku1 |
| ovde pise ona fraza kukuriku2 |
| ovde pise ona fraza kukuriku3 |
+--------------------------------------------+
4 rows in set (0.00 sec)
mysql> update t2 set polje2 = replace(polje2, 'ovaj izraz', 'ona fraza') WHERE polje1 LIKE '(med.)';
Query OK, 4 rows affected (0.06 sec)
Rows matched: 4 Changed: 4 Warnings: 0
mysql> select * from t2;
+----+--------+--------------------------------+
| id | polje1 | polje2 |
+----+--------+--------------------------------+
| 1 | (med.) | ovde pise ona fraza kukuriku |
| 2 | (med.) | ovde pise ona fraza kukuriku1 |
| 3 | (med.) | ovde pise ona fraza kukuriku2 |
| 4 | (med.) | ovde pise ona fraza kukuriku3 |
| 5 | aaa | ovde pise ovaj izraz kukuriku3 |
| 6 | aaa | ovde pise ovaj izraz kukuriku5 |
+----+--------+--------------------------------+
6 rows in set (0.00 sec)
ne kontam gde je problem? to je tvoj upit i radi to sto hoces ?!