[ pakito @ 01.02.2015. 21:28 ] @
U polju1 nalazi se izraz '(med.)'.
U polju2 dva nalazi se izraz 'Izraz jedan' koji treba svuda gde u polju1 imam '(med.)' da zamenim sa 'Izraz dva'.

Kako da udesim naredbu da mi automatski izvrši ovu izmenu?
Do sada sam uspevao automatski da zamenim jedan izraz drugim, ali bez uslova:

Code:
$unos="UPDATE tabela SET polje2 = replace(polje2, 'ovaj izraz', 'zameni ovim')";


Poslednje što sam pokušao izgledalo je ovako:

Code:
$unos=mysql_query("UPDATE tabela SET polje2 = replace(polje2, 'fraza stara', 'rraza nova') WHERE polje1 LIKE '(med.)' ");


Ne ide. Čekam pomoć.






[ bogdan.kecman @ 01.02.2015. 21:40 ] @
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 ?!
[ galateawoodson @ 03.02.2017. 10:46 ] @
You couldn't imagine how much time I spent looking for a solution of this issue! Even from http://domyhomeworkonline.net/do-my-java-homework.php guys couldn't help me, which is rare.
Thank you so much!
[ carolspencer @ 05.08.2019. 08:40 ] @
Hello there. I'm a newbie here. I can advise to you to come across this https://greatdissertation.com/...pics-for-IT-dissertations.html. I usually use it when I need writing assistance. To my mind, it's the best writing service. On this website you can find any kind of academic paper.
[ lolanickson @ 21.08.2020. 11:58 ] @
Hey guys! Why I am here, because I am a professional writer and your blog is a fantastic magic wand for me which helps me to practise my writing skills, become better in creating different papers and so on. I love my work and for me creating essays is the biggest love in work. But guys who do not know how to handle with different papers for university or school, who do not know how to create review on some books, report or different other statictical analysis, just do not get up! I am here to help you, just visit the site https://papers-land.com/ where I work as a writer and write to customer service the next response "do my homework for me" and you will definitely get the professional answer and feetback from our writer or just me)))