BuddyPress.org

@alice-kaye No need to run complicated SQL queries 😉

1) Click on the wp_options table
2) Click on Search at the top
3) Enter “permalink_structure” into the option_name value box
4) Click “Go”
5) You will see your permalink structure eg : /%postname/% in the option_value field
6) Click on it and put your new one in there or leave it blank for the WP default one.
7) Hit enter! Done!

😉