How to Replace [Size= in mysql ?

[Yodrak]

Hello, i need help in mysql query.
I would like to replace the

[Size=1]
[Size=2]
[Size=3]

to

[Size=4]

From all Fonts in table xf_post between specific Timestamp Dezember 23 2004 and March 03 2016.
I need to use the column post_date but don´t know how to do that.

Anyone who can help me please?

 

[Yugensoft]

https://stackoverflow.com/a/14586441/5132647 explains the basics

 

[Yodrak]

@Yugensoft i tried this from my thinkink. But it´s not working.

UPDATE message
SET str = REPLACE(str,,[SIZE=1]','[Size=4]') WHERE
Timestamp <= 1415463675 AND str LIKE %[SIZE=1]%'

 

[AndyB]

From all Fonts in table xf_post between specific Timestamp Dezember 23 2004 and March 03 2016.

Why not do it on all posts?

 

[Yodrak]

@AndyB Thank you, but that will replace the Size of Fonts in all Posts. The Problem is we migrate from vB4 to Xenforo in March 16. So i would need
a query with Timestamp until March 03 2016.

 

[AndyB]

The Problem is we migrate from vB4 to Xenforo in March 16

What problem are you referring to?

 

[Yodrak]

The fonts displayed to small.

Take a look here:

https://thailand-asienforum.com/threads/angeles-schweine-und-kamagra.8458/page-5#post-252097

 

[Yodrak]

And here is another Example:

https://thailand-asienforum.com/thr...4-i-have-virus-inside.9466/page-9#post-265218

 

[AndyB]

The fonts displayed to small.

Why not just remove the size tags on all the posts?

 

[Yodrak]

Then the Font Size will be to big from March 2016 on. My guess is that the Fonts got wrong converted by the Import from vB. As i can remember in vB the most used Fontsize was 12 points.

 

[AndyB]

Then the Font Size will be to big from March 2016 on

That should not be the case. The font size would be the same for all the posts and can be adjusted in the style properties, but you should not have to do that.

 

[Yodrak]

@AndyB i think we did cross talk but thank you for trying to help me. I know that a BB-Code Size=1 will be everywhere the same. But the Properties Settings before in vB4 was different to the Settings in xenforo i guess. In the past 1.5 years we got 150000 Posts more so i searched a way to make changes in a given Timespace.

In the meanwhile i found the solution with the help of a friend.

UPDATE xf_post
SET message= REPLACE(message, "[SIZE=1]", "[SIZE=4]")
WHERE post_date >= UNIX_TIMESTAMP("2004-04-04") AND post_date <= UNIX_TIMESTAMP("2016-03-08")
    AND message LIKE "%[SIZE=4]%"