I need to modify wp_options table

@Gabriela, it looks like you’ve clicked on the link that takes you to the structure of the table, and that you’re trying to modify that. I think what you want is to click on the link to the left of the table name (in your case, “registros”). That will show you the data in the table, and allow you to edit it. Clicking on the name of the table in Adminer allows you to view the table’s structure.

That said, you may also find a plugin like WP Migrate (or Better Search and Replace) to be a better tool to search and replace the hostname/URL throughout the database, as opposed to manually working through the database tables (wp_options is only one place where the URL ends up in the data). I only mention WP Migrate as the first suggestion as it is incredibly useful for this purpose, but offers so much more in the migration of WP sites.

Hope this helps.

1 Like