escape quotes

Hi,

I'm trying to replace this:

but

UPDATE `jos_content` SET `introtext` = replace(`introtext`," 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;\">","

")

just gives me 0 results...

How do I correctly replace and unescape the quote?

Thanks!

--
Lex Thoonen
Pêng Smart Web Design - http://www.peng.nl
Gran Canaria Info - http://www.gran-canaria-info.com
Hollandse Nieuwe - http://www.hollandsenieuwe.com
tel. +34 928 88.61.77


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: escape quotes

Lex Thoonen,all

> UPDATE `jos_content` SET `introtext` = replace(`introtext`," > 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;\">","

")
>
> just gives me 0 results...

How about this?

UPDATE `jos_content` set `introtext` = "

" where `introtext` = "

";

(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=gcdmg-mysql-2@m.gmane.org

Mysql service will not stop

I have mysql 5.0.51a running on a linux 2.6.26 box. The service my6sql
stop command fails and all that appears in the log or err log is the
following... what can I do to repair this?

091014 17:00:24 guardian: instance 'mysqld' is running, set state to
STARTED.
091014 17:07:40 The instance 'mysqld' is being stopped forcibly.
Normallyit should not happen. Probably the instance has beenhanging. You
should also check your IM setup
091014 17:07:40 Listener_thread::run(): shutdown requested, exiting...


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql service will not stop

It is Innodb. but most of our other identical database deployments seem
to shutdown immediately, just not this one using the same image...
>> Since dirty buffers needs to flush out.
>>
>> Thanks,
>> Dilipkumar
>> Database Engineering
>> Mphasis, an EDS company
>>  phone: +91-44-6637 3167
>>  mailto: dilipkumar.parikh@eds.com
>> Pager mail:9884430998@nma.vodafone.in
>>
>>
>> -----Original Message-----
>> From: Bryan Cantwell [mailto:bcantwell@firescope.com]
>> Sent: Wednesday, October 14, 2009 8:40 PM
>> To: mysql@lists.mysql.com
>> Subject: Mysql service will not stop
>>
>> I have mysql 5.0.51a running on a linux 2.6.26 box. The service my6sql
>> stop command fails and all that appears in the log or err log is the
>> following... what can I do to repair this?
>>
>> 091014 17:00:24 guardian: instance 'mysqld' is running, set state to
>> STARTED.
>> 091014 17:07:40 The instance 'mysqld' is being stopped forcibly.
>> Normallyit should not happen. Probably the instance has beenhanging. You
>> should also check your IM setup
>> 091014 17:07:40 Listener_thread::run(): shutdown requested, exiting...
>>
>>
>>
>>
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Mysql service will not stop

Brian,

You could spend a lot of time crawling through version release notes
looking for something which might refer to your issue, or you might
just upgrade to 5.0.86-0 which is the latest 5.0. There have been
close to 2 years worth of bug-fixes since 5.0.51a

- michael dykman


On Wed, Oct 14, 2009 at 11:10 AM, Bryan Cantwell
wrote:
> I have mysql 5.0.51a running on a linux 2.6.26 box. The service my6sql st=
op
> command fails and all that appears in the log or err log is the following=
....
> what can I do to repair this?
>
> 091014 17:00:24 =A0 =A0guardian: instance 'mysqld' is running, set state =
to
> STARTED.
> 091014 17:07:40 =A0 =A0The instance 'mysqld' is being stopped forcibly.
> Normallyit should not happen. Probably the instance has beenhanging. You
> should also check your IM setup
> 091014 17:07:40 =A0 =A0Listener_thread::run(): shutdown requested, exitin=
g...
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>



--=20
- michael dykman
- mdykman@gmail.com

Don=92t worry about people stealing your ideas. If they=92re any good,
you=92ll have to ram them down their throats!

Howard Aiken

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg