Re: escape quotes
Lex Thoonen,all UPDATE `jos_content` SET `introtext` = replace(`introtext`,h2 style=\margin: 0px 0px 5px; padding: 0px; font-family: 'Trebuchet MS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px; font-size: 30px; color: #b4b4be;\,h2) just gives me 0 results... How about this? UPDATE `jos_content` set `introtext` = h2 where `introtext` = h2 style=\margin: 0px 0px 5px; padding: 0px; font-family: 'TrebuchetMS',Arial,Helvetica,sans-serif; font-weight: bold; line-height: 30px;font-size: 30px; color: #b4b4be;\; (this query executed by MySQL ver 5.1.34-community) yusuke kadota -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
About NoWait of MySql
Hi, MySQL Developers I'm a beginner of MySQL, and so I'm in a trobble. in MySQL 5.0.45 and acctually, I'm trying to migration my application from Oracle to MySQL I'd like to use nowait option (of Oracle) in MySQL when locking one record. but I could not find nowait oitpin in MySQL. so I have some question to solve. 1. Does MySQL have lock option like Oracle's nowait or alternative way. acctually I'd not like to use innodb_lock_wait_timeout configuration. for some reasons... 2. Do you hava a plan to implement nowait option to the latest MySQL (and the what version of MySQL will you plan to implement) I'm sorry for my poor English, and I'd appriciate if you would answer my questions. thanks in advance, Yusuke. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org