Delete a word from a string in mysql row

Question

Am trying to delete a word from a string in my database

The string is $keywords = tech,sms,libya,tax

Suppose i want to remove libya from the string how do i go about this

Joe Landsman · Accepted Answer · 2011-08-22 16:36:10Z

3

I think for the clarity you might want to explode the string into an array, remove the unwanted element and then reconstruct the string. Like this:

$keywords = 'tech,sms,libya,tax';       // Set String
$keywords = explode(',', $keywords);    // Explode into array
unset($keywords[ array_search('libya', $keywords) ]);   // Unset the array element with value of 'libya'
$keywords = implode(',',$keywords);     // Reconstruct string

answered Aug 22, 2011 at 16:36

Joe Landsman

2,17713 silver badges9 bronze badges

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

Comments

Rijk · Accepted Answer · 2011-08-22 16:20:07Z

1

Use MySQL's REPLACE function.

answered Aug 22, 2011 at 16:20

Rijk

11.3k3 gold badges33 silver badges46 bronze badges

Collectives™ on Stack Overflow

Delete a word from a string in mysql row

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related