WP_Meta_Query::get_cast_for_type() – Method

WP_Meta_Query::get_cast_for_type( string $type = '' ): string

Returns the appropriate alias for the given meta type if applicable.

Parameters

$typestringoptional: MySQL type to cast meta_value.
Default:''

Return

string MySQL type.

Source

public function get_cast_for_type( $type = '' ) {
	if ( empty( $type ) ) {
		return 'CHAR';
	}

	$meta_type = strtoupper( $type );

	if ( ! preg_match( '/^(?:BINARY|CHAR|DATE|DATETIME|SIGNED|UNSIGNED|TIME|NUMERIC(?:\(\d+(?:,\s?\d+)?\))?|DECIMAL(?:\(\d+(?:,\s?\d+)?\))?)$/', $meta_type ) ) {
		return 'CHAR';
	}

	if ( 'NUMERIC' === $meta_type ) {
		$meta_type = 'SIGNED';
	}

	return $meta_type;
}

View all references View on Trac View on GitHub

Used by	Description
WP_Meta_Query::get_sql_for_clause()`wp-includes/class-wp-meta-query.php`	Generates SQL JOIN and WHERE clauses for a first-order query clause.

Changelog

Version	Description
3.7.0	Introduced.

User Contributed Notes

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