Removing a Part of Text from Database Field

akrashdi · #1 (**permalink**) 09-19-11, 02:01

Hi,

I have the following in a field, which appears in many records:

common-words/someword

I wanna to change this to

expressions/someword

How should I write the SQL query for this.

Appreciated...

r937 · #2 (**permalink**) 09-19-11, 06:04

Code:

UPDATE daTable
   SET afield = REPLACE(afield,'common-words/someword','expressions/someword')

akrashdi · #3 (**permalink**) 09-19-11, 15:46

hmmm.....

Actually 'someword' means there are many records of different words in the table, i.e.

common-words/mufassir
common-words/muhaddith
common-words/faqiih
common-words/muhaqqiq
....

I wanna to change all these records to, lets say:

expressions/mufassir
expressions/muhaddith
expressions/faqiih
expressions/muhaqqiq

r937 · #4 (**permalink**) 09-19-11, 15:50

Code:

UPDATE daTable
   SET afield = REPLACE(afield,'common-words/','expressions/')

akrashdi · #5 (**permalink**) 09-19-11, 19:30

Oops.. there is a REPLACE function for that, I need to get some proper training for SQL.

Thanks.

healdem · #6 (**permalink**) 09-20-11, 03:16

well its either that or look at da manuel
or possibly both

Internet Services

Web Development

Digital Marketing

Consumer Tech