Automattic\WooCommerce\Internal\Utilities

DatabaseUtil::create_fts_index_order_address_table()publicWC 1.0

Create a fulltext index on order address table.

Method of the class: DatabaseUtil{}

No Hooks.

Return

null. Nothing (null).

Usage

$DatabaseUtil = new DatabaseUtil();
$DatabaseUtil->create_fts_index_order_address_table(): void;

DatabaseUtil::create_fts_index_order_address_table() code WC 9.3.3

public function create_fts_index_order_address_table(): void {
	global $wpdb;
	$address_table = $wpdb->prefix . 'wc_order_addresses';
	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $address_table is hardcoded.
	$wpdb->query( "CREATE FULLTEXT INDEX order_addresses_fts ON $address_table (first_name, last_name, company, address_1, address_2, city, state, postcode, country, email)" );
}