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

Used internally to generate an SQL string for searching across multiple columns.


Parameters

$search

(Required) Search string.

$columns

(Required) Array of columns to search.


Return

(string) Search SQL.


Source

File: wp-includes/class-wp-comment-query.php

	protected function get_search_sql( $string, $cols ) {
		global $wpdb;

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

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

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


Changelog

Changelog
Version Description
3.1.0 Introduced.