wpdb::get_table_from_query( string $query ): string|false

3796	protected function get_table_from_query( $query ) {3797		// Remove characters that can legally trail the table name.3798		$query = rtrim( $query, ';/-#' );3799 3800		// Allow (select...) union [...] style queries. Use the first query's table name.3801		$query = ltrim( $query, "\r\n\t (" );3802 3803		// Strip everything between parentheses except nested selects.3804		$query = preg_replace( '/\((?!\s*select)[^(]*?\)/is', '()', $query );3805 3806		// Strip any leading SET STATEMENT statements.3807		$query = preg_replace( '/^SET STATEMENT.+?\sFOR\s+/is', '', $query );3808 3809		// Quickly match most common queries.3810		if ( preg_match(3811			'/^\s*(?:'3812				. 'SELECT.*?\s+FROM'3813				. '|INSERT(?:\s+LOW_PRIORITY|\s+DELAYED|\s+HIGH_PRIORITY)?(?:\s+IGNORE)?(?:\s+INTO)?'3814				. '|REPLACE(?:\s+LOW_PRIORITY|\s+DELAYED)?(?:\s+INTO)?'3815				. '|UPDATE(?:\s+LOW_PRIORITY)?(?:\s+IGNORE)?'3816				. '|DELETE(?:\s+LOW_PRIORITY|\s+QUICK|\s+IGNORE)*(?:.+?FROM)?'3817			. ')\s+((?:[0-9a-zA-Z$_.`-]|[\xC2-\xDF][\x80-\xBF])+)/is',3818			$query,3819			$maybe3820		) ) {3821			return str_replace( '`', '', $maybe[1] );3822		}3823 3824		// SHOW TABLE STATUS and SHOW TABLES WHERE Name = 'wp_posts'3825		if ( preg_match( '/^\s*SHOW\s+(?:TABLE\s+STATUS|(?:FULL\s+)?TABLES).+WHERE\s+Name\s*=\s*("|\')((?:[0-9a-zA-Z$_.-]|[\xC2-\xDF][\x80-\xBF])+)\\1/is', $query, $maybe ) ) {3826			return $maybe[2];3827		}3828 3829		/*3830		 * SHOW TABLE STATUS LIKE and SHOW TABLES LIKE 'wp\_123\_%'3831		 * This quoted LIKE operand seldom holds a full table name.3832		 * It is usually a pattern for matching a prefix so we just3833		 * strip the trailing % and unescape the _ to get 'wp_123_'3834		 * which drop-ins can use for routing these SQL statements.3835		 */3836		if ( preg_match( '/^\s*SHOW\s+(?:TABLE\s+STATUS|(?:FULL\s+)?TABLES)\s+(?:WHERE\s+Name\s+)?LIKE\s*("|\')((?:[\\\\0-9a-zA-Z$_.-]|[\xC2-\xDF][\x80-\xBF])+)%?\\1/is', $query, $maybe ) ) {3837			return str_replace( '\\_', '_', $maybe[2] );3838		}3839 3840		// Big pattern for the rest of the table-related queries.3841		if ( preg_match(3842			'/^\s*(?:'3843				. '(?:EXPLAIN\s+(?:EXTENDED\s+)?)?SELECT.*?\s+FROM'3844				. '|DESCRIBE|DESC|EXPLAIN|HANDLER'3845				. '|(?:LOCK|UNLOCK)\s+TABLE(?:S)?'3846				. '|(?:RENAME|OPTIMIZE|BACKUP|RESTORE|CHECK|CHECKSUM|ANALYZE|REPAIR).*\s+TABLE'3847				. '|TRUNCATE(?:\s+TABLE)?'3848				. '|CREATE(?:\s+TEMPORARY)?\s+TABLE(?:\s+IF\s+NOT\s+EXISTS)?'3849				. '|ALTER(?:\s+IGNORE)?\s+TABLE'3850				. '|DROP\s+TABLE(?:\s+IF\s+EXISTS)?'3851				. '|CREATE(?:\s+\w+)?\s+INDEX.*\s+ON'3852				. '|DROP\s+INDEX.*\s+ON'3853				. '|LOAD\s+DATA.*INFILE.*INTO\s+TABLE'3854				. '|(?:GRANT|REVOKE).*ON\s+TABLE'3855				. '|SHOW\s+(?:.*FROM|.*TABLE)'3856			. ')\s+\(*\s*((?:[0-9a-zA-Z$_.`-]|[\xC2-\xDF][\x80-\xBF])+)\s*\)*/is',3857			$query,3858			$maybe3859		) ) {3860			return str_replace( '`', '', $maybe[1] );3861		}3862 3863		return false;3864	}
When	Instructions	Calls it makes
`preg_match()`	27	`rtrim(), ltrim(), preg_match()`
always	31	`rtrim(), ltrim(), preg_match(), preg_match()`
always	39	`rtrim(), ltrim(), preg_match(), preg_match(), preg_match()`
`!preg_match()`	42–45	`rtrim(), ltrim(), preg_match(), preg_match(), preg_match(), preg_match()`
PHP	Compiled	Executed	Branches	Notes
8.6-dev	56	27–45	4
8.5	56	27–45	4
8.4	56	27–45	4	15 fewer instructions than PHP 8.3
8.3	71	36–54	4
8.2	71	36–54	4
8.1	71	36–54	4
7.4	71	36–54	4