WP_Comment_Query::get_search_sql() WordPress Method

The WP_Comment_Query::get_search_sql() method is used to generate the SQL code that will be used to search for comments based on the specified search terms. This is useful for plugins that want to search through comments for specific data.

WP_Comment_Query::get_search_sql( string $search, string[] $columns ) #

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

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

		$searches = array();
		foreach ( $columns as $column ) {
			$searches[] = $wpdb->prepare( "$column LIKE %s", $like );
		}

		return ' AND (' . implode( ' OR ', $searches ) . ')';
	}