Mysql Update

NetworkTown.Net · Oct 9, 2006

Hi

Dose any one know of a script that can do the following:

When i type in a form .flv and submit the form will update all .wmv in my database to .flv is it possible?

Noobie · Oct 9, 2006

The sql is:
UPDATE {TABLE_NAME} SET {FIELD_NAME} = REPLACE ({FIELD_NAME}, '.wmv', '.flv' )

NetworkTown.Net · Oct 9, 2006

Ok so if my DB name is arcade and the table is games it will look like this:

UPDATE {user_arcade} SET {games} = REPLACE ({games}, '.wmv', '.flv' )

Is that correct?

Noobie · Oct 9, 2006

minus the braces.

UPDATE user_arcade SET games = REPLACE (games, '.wmv', '.flv' )

NetworkTown.Net · Oct 9, 2006

Thanks i will test it in abit.

imageshispanoamericaines.fr

making-of-lexikon.de

videochat.today

cinecalidad.ai

ashtrevino.info

dendra.io

sidaq.org

italycafferistorante.pt

archersclub.co

laiseundruhm.de

Mysql Update

Account Closed

Established Member

Account Closed

Established Member

Account Closed

T.Live

E.games

O-O.com

StudentCircle.com

Reveal.com

MommaBear.com

JustPasteIt.com

WMD.com

PINK.net

Money.money

Similar threads

We're social

T.Live

E.games

O-O.com

StudentCircle.com

Reveal.com

MommaBear.com

JustPasteIt.com

WMD.com

PINK.net

Money.money

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy