I ran a query that deleted all content in post_name (used for SEO-friendly URLs) column.

UPDATE wp_posts SET post_name = ''

I thought that WordPress would automatically populate new ones if I update the permalink structure but I was wrong.

I also tried this function and still no luck.

Is there anyway to at least get the links working again?