How can I use this string replace in MySQL

Question

I'm using Wordpress and have a load of custom fields where I need to do a string replace on. Basically I have a price field which is in the example format: from 113.800

I need to remove the word 'from', the space after it and the dot between the number. All the fields are in this format, how can I use a MySQL replace function to do this?

Thanks

Bill Karwin · Accepted Answer · 2014-03-14 21:16:55Z

1

REPLACE() doesn't support regular expression matching, so you'll have to do it in a more clumsy way:

UPDATE wp_sometable
SET price_field = REPLACE(REPLACE(price_field, 'from ', ''), '.', '');

answered Mar 14, 2014 at 21:16

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

How can I use this string replace in MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related