How Yoast SEO plugin works with variable %%name%%?

It does not create tables, it stores data the “WordPress way” in the postmeta table, which is common to all WordPress functions. Because it’s common to all WordPress functions, the ID’s are going to be out of sequence for Yoast data, because it’s going to be “commingled” with much other data that gets stored in that table.

As to your question about the %%name%% variable, it appears you are trying to use the variable inside your post title, which you cannot do. For it to work, you’d need to do something like so, in your Titles & Meta Settings:

%%title%% - by %%name%%

IMPORTANT UPDATE
This actually is a bug in the preview feature on the post (as of version 2.3.5, and up to and including version 3.0.7). The variable %%name%% is NOT getting parsed properly.

However, if you view the page itself, the variables are being parsed properly, including the %%name%% variable.

Related Posts:

  1. What is the difference between an ORM and an ODM?
  2. Rename a table in MySQL
  3. How should I tackle –secure-file-priv in MySQL?
  4. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  5. Keeping WP database synced across multiple developers using git
  6. Staging sites, how do you manage synchronising updates in the DB?
  7. How to get the post publish date outside the loop?
  8. Using transients in conjunction with memcached
  9. How to define composite keys with dbDelta()
  10. Has parent field in the table wp_term_taxonomy has term_id or term_taxonomy_id
  11. Forcing nickname as display_name in custom edit profile template
  12. Connect forms in WP to external database
  13. Hook into $wpdb
  14. How to get site URL if database is disconnected?
  15. Is it wise to delete post revisions and autosaves from database?
  16. Showing content from another wordpress installation database in the page template loop?
  17. Multiple WP install with same users database
  18. Dynamic data in `wp_register_script` needed
  19. Why is $wpdb->get_results failing on certain tables but not others (which have data)?
  20. Using two different DB users on one WP install
  21. Usage of Direct Database Call Without Caching Error
  22. Can I transfer a mysql database to another site?
  23. How to verify password outside WordPress?
  24. Weird issue with database migration and SSL links
  25. Backup another database with BackUpWordPress plugin [closed]
  26. Easiest Way to Authenticate WP Users Using an External DB?
  27. How to use a different database to list and manage comments in the backend
  28. wpdb_prepare with multiple or condition
  29. WordPress Install and Database on separate hosting?
  30. Moving a site from a temporary domain to the live domain [duplicate]
  31. Error establishing a database connection on Installation
  32. What is this in my tables
  33. Why is it that not all users have a ‘session_tokens’ meta_key record in the usermeta table?
  34. How do I find out the full path of a page’s template?
  35. WP get stuck with a query on MySQL when the site is resumed
  36. Use mulitple usernames?
  37. Routine to convert custom post meta from old to new value
  38. “The link you followed has expired” & “Error while saving” messages when adding new post
  39. input data and output table [closed]
  40. Trying to change database tables storage engine to innodb gives error “invalid default value for ‘post_date'”
  41. database connection [closed]
  42. sanitize POST arrays
  43. WP character encoding error after sharing post on Facebook �
  44. Sending data with multi step form to wp database
  45. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  46. WordPress query is not returning proper results
  47. Undefined Variable: mysqli error when connecting to database
  48. Localhost to Staging to Development Dynamic WP-CONFIG
  49. Is there an atomic way to update_option in WordPress (to ensure data integrity)?
  50. All text disappeared (seems to be a database problem) [closed]
  51. is wordpress stores Role Id in WP database?
  52. Why do database examples sometimes finish with an add_option call?
  53. Is it possible to have more than 1 MySQL database in my WordPress blog?
  54. How and where is wordpress adding mySQL content to database?
  55. restore a db after bad backup
  56. Best practice to import user base (subscribers) from one website to another?
  57. AJAX wp-mysql running too slow
  58. Some weird users in database
  59. Delete/Replace words from X to Y in post content
  60. How to delete a particular row in a database table
  61. Location of image metadata on my server
  62. How to create more than one new wpdb object?
  63. Connecting to wordpress database in my application [closed]
  64. Is it good practice to import/export a blog to test a redesign?
  65. Getting value from database table depending on field value
  66. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  67. Secure way to use name_save_pre?
  68. wpdb->insert not inserting first variable
  69. Database tables for sports betting integrated in WordPress
  70. change the year on all of my custom post types?
  71. WordPress keeps redirecting to localhost
  72. get value from ‘terms’ table
  73. custom tables in wordpress Database? (can i just create them with sql?)
  74. New installation fatal error in 5.9.3 at edit or create entry
  75. Storing transients giving database error
  76. I want to replicate a wordpress website over multiple servers
  77. Displaying requested data from a the database in wordpress
  78. Accidently changed the GUID
  79. Is there anyway to split posts to different databases?
  80. wp-cli + valet: “Error establishing a database connection”
  81. local wordpress broke after changing URL
  82. Unable to login to a https website via the app after changing from http
  83. Is it safe to add INDEX to a column in WordPress database?
  84. Restore Old Database Over Newer WP & Plugin Files
  85. WP website showing blank page after moving from subdomain to main domain
  86. Not sure what to do next to optimize
  87. Database structure for thousands of posts
  88. How do I find out from my database what version of WordPress I need?
  89. How to create a database table?
  90. Accessing content from third party as native posts in WordPress
  91. Extracted CSV as Array for Custom Query Loop
  92. Hang Up Followed By Can’t select database
  93. Database error after importing WordPress
  94. One WP Database outside localhost and two connections
  95. Fetch data from another site, but the same database
  96. Every time I update or install a plugin I get “Error Establishing a Database Connection in WordPress”
  97. Create hundreds of users with just ID in phpMyAdmin
  98. Upload wordpress from localhost to 000webhost
  99. Cant Connect to Database
  100. WordPress database connection failed, while mysql client is working [closed]
error code: 523