WP_User_Query::get_search_sql( string $search, string[] $columns, bool $wild = false ): string

943	protected function get_search_sql( $search, $columns, $wild = false ) {944		global $wpdb;945 946		$searches      = array();947		$leading_wild  = ( 'leading' === $wild || 'both' === $wild ) ? '%' : '';948		$trailing_wild = ( 'trailing' === $wild || 'both' === $wild ) ? '%' : '';949		$like          = $leading_wild . $wpdb->esc_like( $search ) . $trailing_wild;950 951		foreach ( $columns as $column ) {952			if ( 'ID' === $column ) {953				$searches[] = $wpdb->prepare( "$column = %s", $search );954			} else {955				$searches[] = $wpdb->prepare( "$column LIKE %s", $like );956			}957		}958 959		return ' AND (' . implode( ' OR ', $searches ) . ')';960	}