UCC Dynamic Content Modifier

Click anywhere to close this box

Using SQL Queries:
To use SQL queries, put the search term in the first box
then put a valid SQL query in the second box, and hit search.

Operator	Description	Example
=	Equal to	SELECT * FROM employees WHERE department = 'IT';
<> or !=	Not equal to	SELECT * FROM products WHERE category <> 'Electronics';
<	Less than	SELECT * FROM orders WHERE order_date < '2022-01-01';
>	Greater than	SELECT * FROM prices WHERE price > 50.00;
<=	Less than or equal to	SELECT * FROM grades WHERE score <= 80;
>=	Greater than or equal to	SELECT * FROM customers WHERE age >= 21;
LIKE	Pattern matching	SELECT * FROM products WHERE product_name LIKE 'Ap%';
IN	Matches any value in a list	SELECT * FROM students WHERE grade IN ('A', 'B', 'C');
AND	Logical AND	SELECT * FROM orders WHERE order_date > '2022-01-01' AND total_amount > 100.00;
OR	Logical OR	SELECT * FROM employees WHERE department = 'HR' OR department = 'Finance';
NOT	Logical NOT	SELECT * FROM users WHERE NOT status = 'Inactive';

Column Name	Description
ID	Unique identifier for the post.
post_author	ID of the user who wrote the post.
post_date	Date and time when the post was created.
post_content	Main content of the post.
post_title	Title of the post.
post_status	Status of the post (e.g., publish, draft, pending).
post_name	URL-friendly version of the post title.
post_modified	Date and time when the post was last modified.
post_parent	ID of the parent post for hierarchical post types.
guid	Global Unique Identifier for the post.
post_type	Type of the post (e.g., post, page, attachment).

Please enter password:

Password:

Modify Content:

Complete a search to import for modification

Select posts you wish to modify

Select	ID	Date	Status	Title	URL	Post Type

Process Modifications

Search Term

Replace Term

ID	Title	URL

Connect to Database:

Enter database information from Pantheon to connect

Not connected...

Dev Live

IP Address:
Port:
Username:
Password:
Database:

Export CSV file:

Export a .csv file that can be imported into excel.

Database Search:

Query Mode

Search Term:

Search Query:

ID	Date	Status	Title	URL	Post Type	Post Content	Permalink	Post Name	Post Title	Meta Values