Use value instead of ID for the primary key column

2ndkauboy · 2ndkauboy · commit beccc585b25e · 2024-04-26T16:28:49.000+02:00
diff --git a/src/DB_Command.php b/src/DB_Command.php
@@ -1301,14 +1301,14 @@ public function prefix() {
 	 *
 	 *     # Search for a string and print the result as a table
 	 *     $ wp db search https://localhost:8889 --format=table
-	 *     +------------+--------------+-----------+----+-----------------------------+
-	 *     | table      | column       | key       | ID | match                       |
-	 *     +------------+--------------+-----------+----+-----------------------------+
-	 *     | wp_options | option_value | option_id | 1  | https://localhost:8889      |
-	 *     | wp_options | option_value | option_id | 2  | https://localhost:8889      |
-	 *     | wp_posts   | guid         | ID        | 1  | https://localhost:8889/?p=1 |
-	 *     | wp_users   | user_url     | ID        | 1  | https://localhost:8889      |
-	 *     +------------+--------------+-----------+----+-----------------------------+
+	 *     +------------+--------------+-----------+-------+-----------------------------+
+	 *     | table      | column       | key       | value | match                       |
+	 *     +------------+--------------+-----------+-------+-----------------------------+
+	 *     | wp_options | option_value | option_id | 1     | https://localhost:8889      |
+	 *     | wp_options | option_value | option_id | 2     | https://localhost:8889      |
+	 *     | wp_posts   | guid         | ID        | 1     | https://localhost:8889/?p=1 |
+	 *     | wp_users   | user_url     | ID        | 1     | https://localhost:8889      |
+	 *     +------------+--------------+-----------+-------+-----------------------------+
 	 *
 	 *     # Search for a string and get only the IDs (only works for a single table)
 	 *     $ wp db search https://localhost:8889 wp_options --format=ids
@@ -1504,7 +1504,7 @@ public function search( $args, $assoc_args ) {
 			$formatter_args   = [
 				'format' => $format,
 			];
-			$formatter_fields = [ 'table', 'column', 'key', 'ID', 'match' ];
+			$formatter_fields = [ 'table', 'column', 'key', 'value', 'match' ];
 
 			if ( $fields ) {
 				$fields           = explode( ',', $assoc_args['fields'] );
