Advertisement
niammuddin

AZ Wordpress Category by Title First Words

Mar 24th, 2018
245
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.44 KB | None | 0 0
  1.  
  2.  
  3. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id)
  4. SELECT ID, '4' SELECT * FROM `wp_posts` WHERE post_title LIKE 'a%'
  5.  
  6. SELECT * FROM `wp_posts` WHERE post_title LIKE 'a%'
  7.  
  8.  
  9. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '64' FROM `wp_posts` WHERE post_title LIKE 'a%';
  10. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '65' FROM `wp_posts` WHERE post_title LIKE 'b%';
  11. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '66' FROM `wp_posts` WHERE post_title LIKE 'c%';
  12. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '67' FROM `wp_posts` WHERE post_title LIKE 'd%';
  13. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '68' FROM `wp_posts` WHERE post_title LIKE 'e%';
  14. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '69' FROM `wp_posts` WHERE post_title LIKE 'f%';
  15. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '70' FROM `wp_posts` WHERE post_title LIKE 'g%';
  16. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '71' FROM `wp_posts` WHERE post_title LIKE 'h%';
  17. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '72' FROM `wp_posts` WHERE post_title LIKE 'i%';
  18. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '73' FROM `wp_posts` WHERE post_title LIKE 'j%';
  19. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '74' FROM `wp_posts` WHERE post_title LIKE 'k%';
  20. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '75' FROM `wp_posts` WHERE post_title LIKE 'l%';
  21. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '76' FROM `wp_posts` WHERE post_title LIKE 'm%';
  22. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '77' FROM `wp_posts` WHERE post_title LIKE 'n%';
  23. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '78' FROM `wp_posts` WHERE post_title LIKE 'o%';
  24. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '79' FROM `wp_posts` WHERE post_title LIKE 'p%';
  25. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '80' FROM `wp_posts` WHERE post_title LIKE 'q%';
  26. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '81' FROM `wp_posts` WHERE post_title LIKE 'r%';
  27. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '82' FROM `wp_posts` WHERE post_title LIKE 's%';
  28. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '83' FROM `wp_posts` WHERE post_title LIKE 't%';
  29. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '84' FROM `wp_posts` WHERE post_title LIKE 'u%';
  30. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '85' FROM `wp_posts` WHERE post_title LIKE 'v%';
  31. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '86' FROM `wp_posts` WHERE post_title LIKE 'w%';
  32. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '87' FROM `wp_posts` WHERE post_title LIKE 'x%';
  33. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '88' FROM `wp_posts` WHERE post_title LIKE 'y%';
  34. INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '89' FROM `wp_posts` WHERE post_title LIKE 'z%';
  35.  
  36.  
  37. A
  38. B
  39. C
  40. D
  41. E
  42. F
  43. G
  44. H
  45. I
  46. J
  47. K
  48. L
  49. M
  50. N
  51. O
  52. P
  53. Q
  54. R
  55. S
  56. T
  57. U
  58. V
  59. W
  60. X
  61. Y
  62. Z
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement