[es] - Multireplace u MySQL sa uslovom

pakito
Paun Es Durlic
kustos etnolog (u penziji!) i programer
naivac
Majdanpek * Pančevo

Član broj: 91953
Poruke: 273
*.dynamic.isp.telekom.rs.

Sajt: www.PaunDurlic.com

+3 Profil

Multireplace u MySQL sa uslovom

^{01.02.2015. u 21:28 - pre 112 meseci}

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ć.

Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.dynamic.sbb.rs.

Sajt: mysql.rs

+2377 Profil

Re: Multireplace u MySQL sa uslovom

^{01.02.2015. u 21:40 - pre 112 meseci}

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 ?!

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Odgovor na temu

galateawoodson
Thomas Kelly
[email protected]
Stratacard

Član broj: 336196
Poruke: 1
23.106.22.*

Profil

Re: Multireplace u MySQL sa uslovom

^{03.02.2017. u 10:46 - pre 87 meseci}

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!

Odgovor na temu

carolspencer
Carol Spencer
Writer
Writing
Morriton

Član broj: 340696
Poruke: 1
23.227.142.*

Sajt: https://greatdissertation..

Profil

Re: Multireplace u MySQL sa uslovom

^{05.08.2019. u 08:40 - pre 57 meseci}

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.

Odgovor na temu

lolanickson
Lola Nickson
New York
Papers-Land
New York

Član broj: 345220
Poruke: 1
*.pool.ukrtel.net.

Sajt: https://papers-land.com

Profil

Re: Multireplace u MySQL sa uslovom

^{21.08.2020. u 11:58 - pre 44 meseci}

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)))

Odgovor na temu