SQL Find & Replace part of a string

Question

I'm trying to find certain text "catid=18" in a string, where each string is different except for this. I've used this query below before, except it only seems to work if you know the entire string.

update TABLE_NAME
set FIELD_NAME = replace(FIELD_NAME, 'findthis', 'replacewiththis');

You want to find a string and use replace? Could you please give more info. — juergen d
– juergen d, Commented Apr 14, 2012 at 13:06

juergen d · Accepted Answer · 2012-04-14 13:18:12Z

1

Not sure if that is what you want. But it will return 1 if catid=any_num is found and 0 if not:

select 'some_text catid=18 some_text' REGEXP 'catid=[0-9]+'

edited Apr 14, 2012 at 13:18

answered Apr 14, 2012 at 13:13

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wildplasser · Accepted Answer · 2012-04-14 13:19:50Z

1

Maybe you need:

update TABLE_NAME
set FIELD_NAME = 'goodvalue'
WHERE FIELD_NAME = 'badvalue';

answered Apr 14, 2012 at 13:19

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

3 Comments

Scott Greenwald Over a year ago

To be more specific, here's one of the urls. Im trying to replace the "catid=51" with catid="7". Each url is different: index.php?option=com_content&view=article&id=149:multiple-objectives-when-deciding-to-sell-a-medical-practice&catid=51:articles&Itemid=114

Scott Greenwald Over a year ago

They all exist within the same table and field name, if that helps

wildplasser Over a year ago

Now you are talking about urls. Please show us some real data from real tables instead of your meta-babble.

Collectives™ on Stack Overflow

SQL Find & Replace part of a string

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related