AZ Wordpress Category by Title First Words

INSERT INTO wp_term_relationships (object_id, term_taxonomy_id)
SELECT ID, '4' SELECT * FROM `wp_posts` WHERE post_title LIKE 'a%'

SELECT * FROM `wp_posts` WHERE post_title LIKE 'a%'


INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '64' FROM `wp_posts` WHERE post_title LIKE 'a%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '65' FROM `wp_posts` WHERE post_title LIKE 'b%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '66' FROM `wp_posts` WHERE post_title LIKE 'c%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '67' FROM `wp_posts` WHERE post_title LIKE 'd%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '68' FROM `wp_posts` WHERE post_title LIKE 'e%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '69' FROM `wp_posts` WHERE post_title LIKE 'f%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '70' FROM `wp_posts` WHERE post_title LIKE 'g%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '71' FROM `wp_posts` WHERE post_title LIKE 'h%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '72' FROM `wp_posts` WHERE post_title LIKE 'i%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '73' FROM `wp_posts` WHERE post_title LIKE 'j%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '74' FROM `wp_posts` WHERE post_title LIKE 'k%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '75' FROM `wp_posts` WHERE post_title LIKE 'l%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '76' FROM `wp_posts` WHERE post_title LIKE 'm%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '77' FROM `wp_posts` WHERE post_title LIKE 'n%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '78' FROM `wp_posts` WHERE post_title LIKE 'o%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '79' FROM `wp_posts` WHERE post_title LIKE 'p%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '80' FROM `wp_posts` WHERE post_title LIKE 'q%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '81' FROM `wp_posts` WHERE post_title LIKE 'r%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '82' FROM `wp_posts` WHERE post_title LIKE 's%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '83' FROM `wp_posts` WHERE post_title LIKE 't%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '84' FROM `wp_posts` WHERE post_title LIKE 'u%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '85' FROM `wp_posts` WHERE post_title LIKE 'v%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '86' FROM `wp_posts` WHERE post_title LIKE 'w%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '87' FROM `wp_posts` WHERE post_title LIKE 'x%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '88' FROM `wp_posts` WHERE post_title LIKE 'y%';
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id) SELECT ID, '89' FROM `wp_posts` WHERE post_title LIKE 'z%';


A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z