WP_Term_Query::get_search_sql() – Method

WP_Term_Query::get_search_sql( string $search ): string

Used internally to generate a SQL string related to the ‘search’ parameter.

Parameters

$searchstringrequired: Search string.

Return

string Search SQL.

Source

protected function get_search_sql( $search ) {
	global $wpdb;

	$like = '%' . $wpdb->esc_like( $search ) . '%';

	return $wpdb->prepare( '((t.name LIKE %s) OR (t.slug LIKE %s))', $like, $like );
}

View all references View on Trac View on GitHub

Uses	Description
wpdb::esc_like()`wp-includes/class-wpdb.php`	First half of escaping for `LIKE` special characters `%` and `_` before preparing for SQL.
wpdb::prepare()`wp-includes/class-wpdb.php`	Prepares a SQL query for safe execution.

Used by	Description
WP_Term_Query::get_terms()`wp-includes/class-wp-term-query.php`	Retrieves the query results.

Changelog

Version	Description
4.6.0	Introduced.

User Contributed Notes

You must log in before being able to contribute a note or feedback.