Skip to content

SHOW COLUMNS FROM table needs correctly named columns in result set. #26

Closed

Description

@OllieJones

Users of SHOW COLUMNS FROM table depend on having resultset columns named Field, Type, Null, Key, Default, and maybe Extra.

Activity

  1. self-assigned this
    on Mar 22, 2023
  2. batonac commented on Jul 18, 2023

    @batonac

    Just in case this is missing in the scope of this bug, SHOW COLUMNS FROM should also support LIKE, as in:

    $warehouse_table = $wpdb->prefix . "warehouse";
    $warehouse_address = $wpdb->get_row("SHOW COLUMNS FROM " . $warehouse_table . " LIKE 'phone_instore'");
    
  3. added a commit that references this issue on May 30, 2025
  4. added this to the milestone on Jun 5, 2025
  5. removed this from the milestone on Apr 13, 2026
  6. JanJakes commented on Apr 16, 2026

    @JanJakes
    Member

    This was implemented in trunk and will be included in the 3.0 release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions