HTML Entities in Post Title

It seems like the crux of the question is this:

This causes the first ‘if’ condition to return TRUE and it inserts a
duplicate post.

Check for the post_name instead. That value is normalized to lowercase and dashes by sanitize_title_with_dashes so you won’t have this issue. That value is also the one that WordPress enforces as unique, and the one used as a permalink.

Related Posts:

  1. Inserting Hundreds of Thousands of Posts at Once
  2. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  3. Insert two row in wordpress database
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. MySQL error 2006: mysql server has gone away
  6. Which MySQL data type to use for storing boolean values
  7. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  8. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  9. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  10. Your password does not satisfy the current policy requirements
  11. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  12. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  13. what does “/index.php?admin/admin_dashboard” in my url mean
  14. How to join two tables by multiple columns in SQL?
  15. How to get size of mysql database?
  16. Selecting data from two different tables without using joins
  17. SQL – Update multiple records in one query
  18. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  19. mysqladmin: connect to server at ‘localhost’ failed
  20. mysql update multiple columns with same now()
  21. Usage of MySQL’s “IF EXISTS”
  22. How can I loop through all rows of a table? (MySQL)
  23. Generating a random & unique 8 character string using MySQL
  24. MySQL > Table doesn’t exist. But it does (or it should)
  25. SQL select only rows with max value on a column
  26. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  27. mysql count duplicates
  28. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  29. MySQL config file location – redhat linux server
  30. How to create a foreign key in phpmyadmin
  31. Can’t create test file lower test start server mysql
  32. MySQL delete multiple rows in one query conditions unique to each row
  33. Create boolean column in MySQL with false as default value?
  34. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  35. CAST to DECIMAL in MySQL
  36. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  37. MySql – HAVING vs WHERE 
  38. How to stop mysqld
  39. Is merge statement available in MySQL
  40. GROUP_CONCAT comma separator – MySQL
  41. Failed to Connect to MySQL at localhost:3306 with user root
  42. How do you properly prepare a %LIKE% SQL statement?
  43. WordPress MySQL & PHP Performance
  44. SQL query to update post_date (one post = one single date & time)
  45. My WordPress site always displays a cached version of its homepage
  46. Updating User Meta with SQL Query
  47. wpdb prepare syntax
  48. How to run this SQL query of wp_terms database
  49. How to copy post titles to post slug in phpmyadmin
  50. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  51. wp_admin edit.php slow with lots of queries
  52. Database: Custom table: sprintf value for DateTime column
  53. can database and media folder be moved to a different drive?
  54. What is the most secure way to set up the MySQL user in WPMU?
  55. WP_USE_EXT_MYSQL
  56. writing inner join in wpdb
  57. How to get data from WordPress site sql file
  58. Unknown collation when I import a dump from an existing site into a development database?
  59. PHP script can’t connect to Database on port 3307
  60. WordPress with php5-fpm and nginx
  61. Migrating from Existing MySQL Setup to WordPress
  62. How to split the a table in database?
  63. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  64. How to translate this mySQL query to $wpdb query
  65. $wpdb to insert html form information
  66. Proper usage of $wpdb->update()?
  67. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  68. Separate DB by yearly archive of WordPress
  69. What should a WordPress developer know about MySQL? [closed]
  70. Copyright: Get first and last date of post type
  71. Update MySQL query so that it functions again
  72. Query posts by custom taxonomy and sort by post_modified
  73. WordPress $wpdb get posts from category and sort by custom meta
  74. WordPress tables and aliases?
  75. What’s the sql for this condition?
  76. Copy usermeta value where ID matches in the same table
  77. Array Formation Issue
  78. How can I write a formal sql query to get data from a custom table
  79. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  80. WordPress $wpdb no result
  81. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  82. How to run SQL query from WordPress ‘WP Crontrol’ plugin
  83. edit_user_created_user hook – using to update Groups
  84. Changes not being reflected on new server
  85. Mysql Error in querying form entries in Gravity Form plugin
  86. Improving performance of SQL sub-queries in WordPress
  87. MySQL – How to combine data from two tables into one?
  88. Saving custom term value to the database in new table
  89. Stop my loop to register data twice
  90. MySQL errors after a WordPress clone
  91. MYSQL Join on meta key value?
  92. Woocommerce: Grab total revenue of a product over all orders
  93. Complicated MySQL Query
  94. problem with quotes on new post
  95. SQL Database Lost
  96. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  97. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  98. How do I load a sql.gz file to my database? (importing)
  99. How to find source of these strange SQL queries?
  100. Batch Replace URLs in WordPress Database