Hello, Our multisite is using Co-Authors Plus 3.4.92. I'm generating author reports by using SQL to query our databases. So far I've been unable to find a standalone field for the guest author display names. This is what I've found so far:
The wp_terms table has these columns:
Name: john-smith
Slug: cap-john-smith
The wp_term_taxonomy table has the display name combined with the first/last name, ID, etc all in one cell in the description column:
John Smith John Smith john-smith 1234
Is there anywhere I can find the display name separated from the other info, so I can set up a query that will just give me "John Smith" ?
Hello, Our multisite is using Co-Authors Plus 3.4.92. I'm generating author reports by using SQL to query our databases. So far I've been unable to find a standalone field for the guest author display names. This is what I've found so far:
The wp_terms table has these columns: Name: john-smith Slug: cap-john-smith
The wp_term_taxonomy table has the display name combined with the first/last name, ID, etc all in one cell in the description column: John Smith John Smith john-smith 1234
Is there anywhere I can find the display name separated from the other info, so I can set up a query that will just give me "John Smith" ?
Thank you