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

3782	protected function get_table_from_query( $query ) {3783		// Remove characters that can legally trail the table name.3784		$query = rtrim( $query, ';/-#' );3785 3786		// Allow (select...) union [...] style queries. Use the first query's table name.3787		$query = ltrim( $query, "\r\n\t (" );3788 3789		// Strip everything between parentheses except nested selects.3790		$query = preg_replace( '/\((?!\s*select)[^(]*?\)/is', '()', $query );3791 3792		// Quickly match most common queries.3793		if ( preg_match(3794			'/^\s*(?:'3795				. 'SELECT.*?\s+FROM'3796				. '|INSERT(?:\s+LOW_PRIORITY|\s+DELAYED|\s+HIGH_PRIORITY)?(?:\s+IGNORE)?(?:\s+INTO)?'3797				. '|REPLACE(?:\s+LOW_PRIORITY|\s+DELAYED)?(?:\s+INTO)?'3798				. '|UPDATE(?:\s+LOW_PRIORITY)?(?:\s+IGNORE)?'3799				. '|DELETE(?:\s+LOW_PRIORITY|\s+QUICK|\s+IGNORE)*(?:.+?FROM)?'3800			. ')\s+((?:[0-9a-zA-Z$_.`-]|[\xC2-\xDF][\x80-\xBF])+)/is',3801			$query,3802			$maybe3803		) ) {3804			return str_replace( '`', '', $maybe[1] );3805		}3806 3807		// SHOW TABLE STATUS and SHOW TABLES WHERE Name = 'wp_posts'3808		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 ) ) {3809			return $maybe[2];3810		}3811 3812		/*3813		 * SHOW TABLE STATUS LIKE and SHOW TABLES LIKE 'wp\_123\_%'3814		 * This quoted LIKE operand seldom holds a full table name.3815		 * It is usually a pattern for matching a prefix so we just3816		 * strip the trailing % and unescape the _ to get 'wp_123_'3817		 * which drop-ins can use for routing these SQL statements.3818		 */3819		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 ) ) {3820			return str_replace( '\\_', '_', $maybe[2] );3821		}3822 3823		// Big pattern for the rest of the table-related queries.3824		if ( preg_match(3825			'/^\s*(?:'3826				. '(?:EXPLAIN\s+(?:EXTENDED\s+)?)?SELECT.*?\s+FROM'3827				. '|DESCRIBE|DESC|EXPLAIN|HANDLER'3828				. '|(?:LOCK|UNLOCK)\s+TABLE(?:S)?'3829				. '|(?:RENAME|OPTIMIZE|BACKUP|RESTORE|CHECK|CHECKSUM|ANALYZE|REPAIR).*\s+TABLE'3830				. '|TRUNCATE(?:\s+TABLE)?'3831				. '|CREATE(?:\s+TEMPORARY)?\s+TABLE(?:\s+IF\s+NOT\s+EXISTS)?'3832				. '|ALTER(?:\s+IGNORE)?\s+TABLE'3833				. '|DROP\s+TABLE(?:\s+IF\s+EXISTS)?'3834				. '|CREATE(?:\s+\w+)?\s+INDEX.*\s+ON'3835				. '|DROP\s+INDEX.*\s+ON'3836				. '|LOAD\s+DATA.*INFILE.*INTO\s+TABLE'3837				. '|(?:GRANT|REVOKE).*ON\s+TABLE'3838				. '|SHOW\s+(?:.*FROM|.*TABLE)'3839			. ')\s+\(*\s*((?:[0-9a-zA-Z$_.`-]|[\xC2-\xDF][\x80-\xBF])+)\s*\)*/is',3840			$query,3841			$maybe3842		) ) {3843			return str_replace( '`', '', $maybe[1] );3844		}3845 3846		return false;3847	}
When	Instructions	Calls it makes
`preg_match()`	24	`rtrim(), ltrim(), preg_match()`
always	28	`rtrim(), ltrim(), preg_match(), preg_match()`
always	36	`rtrim(), ltrim(), preg_match(), preg_match(), preg_match()`
`!preg_match()`	39–42	`rtrim(), ltrim(), preg_match(), preg_match(), preg_match(), preg_match()`
PHP	Compiled	Executed	Branches	Notes
8.6-dev	53	24–42	4
8.5	53	24–42	4
8.4	53	24–42	4	12 fewer instructions than PHP 8.3
8.3	65	30–48	4
8.2	65	30–48	4
8.1	65	30–48	4
7.4	65	30–48	4