Remove space and replace with _ in phpMyAdmin

Basically I want to take a row in a table which has entries 'example entry' and tur开发者_如何学Cn them into 'example_entry'. There are thousands of entries so I don't want to do it manually, obviously. How would I do this?

Try this:

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

Try with the following query:

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