elearn2014

To publish it as the desired.png shows.

I want to publish the code in the format as the desired.png shows.
Or say, to publish it as the format of code.txt .

• This reply was modified 7 years, 7 months ago by elearn2014.

sql command is more shorter more simple and direct ,more efficient than wp api.
I like sql.

I want to list all my category name.
If there are 3 category names in my category such as c1,c2,c3 ,and 2 tags such as tag1,tag2 in my wordpress.

select name from wp_terms;

The result will be
c1,c2,c3,tag1,tag2.

I want to get only c1,c2,c3 (all of them are category names in my wp),without tag1,tag2.

How to write the proper sql statement?

• This reply was modified 7 years, 10 months ago by elearn2014.

+————-+——+—————————–+———————————–+
| post_status | ID | guid | post_title |
+————-+——+—————————–+———————————–+
| publish | 785 | https://hwy.local/wp/?p=2426 | tar and untar |
| publish | 1470 | https://hwy.local/wp/?p=1470 | debian toolkit |
| inherit | 2964 | https://hwy.local/wp/?p=2964 | tar |
+————-+——+—————————–+———————————–+