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

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

Parameters

$type

(string) (Optional) MySQL type to cast meta_value.

Default value: ''

Return

(string) MySQL type.

Source

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

	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;
	}

Expand Source Code View on GitHub

Related

Used By

Used By
Used By Description
wp-includes/class-wp-meta-query.php: WP_Meta_Query::get_sql_for_clause()

Generate SQL JOIN and WHERE clauses for a first-order query clause.

Changelog

Changelog
Version Description
WP-3.7.0 Introduced.