updating in MySQL

Options

Previous Topic · Next Topic

manzor

Posted: Thursday, June 12, 2008 11:21:09 AM

Rank: Advanced Member
Groups: Member

Joined: 1/31/2008
Posts: 39
Points: 117
Location: GB

updating in MySQL

hi guys

i 'm having problem in searching and replacing text in specific field. well i know about mysql update command and have lookup up regexp but not solved. typical data is : abcQFxyz to chnage to abcQFIxyz.

I got as far as:
UPDATE mytable SET myfield = QFI WHERE part_number REGEXP 'QF';
but I know that wrong.

Thanks for your help.

sachin

Posted: Thursday, June 12, 2008 11:22:15 AM

Rank: Advanced Member
Groups: Member

Joined: 3/3/2008
Posts: 83
Points: 249
Location: India

updating in MySQL

manzor wrote:

try this code

Code:

UPDATE `table_name` SET `field_name` = REPLACE(field_name, 'QF', 'GFI')

Users browsing this topic

Guest

PHP and seo

Boonex Dolphin PHP script is SCAM!!!

Problem in fetching rows from mysql in php?

remommendations for PHP math CAPTCHA script please

avoid php pages getting hacked

sending email with php

Powerful user administration application

please suggest

updating in MySQL

problem with .htaccess

Fantora World » Fantora Coder's community » Programing Languages & Database Development » PHP/MySql » updating in MySQL

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.