Remove space and replace with _ in phpMyAdmin

Question

Basically I want to take a row in a table which has entries 'example entry' and turn them into 'example_entry'. There are thousands of entries so I don't want to do it manually, obviously. How would I do this?

Answer 1

Try with the following query:

UPDATE table SET field = REPLACE(field, ' ', '_');

Answer 2

Try this:

UPDATE your_table
SET your_field = REPLACE(your_field, ' ', '_')