You can do it easily. Your query should be:
$querystr = "SELECT `term_id` AS `id`, `name` AS `value`, `slug`, `term_group` FROM {$wpdb->terms} WHERE lower($wpdb->terms.name) like '%$s%'";
See, here i’ve mentioned the name of the fields needed. For any other fields, you need to explicitly mention the field names.
Related Posts:
- Trash Bin for Categories?
- get_posts assigned to a specific custom taxonomy term, and not the term’s children
- How can I get only parent terms?
- Retrieve posts by term id custom query
- Change order of Custom Taxonomy List
- Get the the top-level parent of a custom taxonomy term
- get_the_term_list without links in 3.1
- Inserting terms in an Hierarchical Taxonomy
- get_terms – only top level
- How to only list the child terms of a taxonomy and not their parents?
- Hierarchical taxonomy UI
- How to prevent new terms being added to a custom taxonomy?
- Order get_terms using a Custom Field
- get_term_children for immediate children only (not grandchildren)
- Query users by custom taxonomy and user role
- Determine Term depth
- How to get current term in my custom taxonomy in WordPress?
- Is there a way to ‘Lock’ a Taxonomy?
- Hide the term description on the term edit page, for a given taxonomy
- Order terms by term_order
- get_term_by not working when in functions.php
- Creating a non-removable taxonomy term
- Get value in custom field with taxonomy [closed]
- Get second level terms of custom taxonomy
- Can I lock down custom taxonomies on a parent term level, but not a child term?
- Get only the first term by taxonomy
- Exclude specific slug in ‘get_terms’
- Large taxonomy (2000+ terms), causing WordPress to hang
- Get terms that contain posts that in turn belong to other terms?
- Custom order of terms for custom taxonomy in admin and website
- Is there a way to disable a term rather than deleting it?
- Modify Term Update Redirection
- Best pratice to make taxonomy terms translatable without changing slugs?
- Front End Post Save Child terms
- Return only the custom sub-term for custom post type, do not echo term-parent
- wp_insert_term is adding a term that has no name
- Taxonomy slug by term ID
- Get total number of comments from posts in a specific custom taxonomy
- Check if current term is a child of another term
- Is there a way to import terms into WordPress?
- get_terms() doesn’t return empty terms even though hide_empty is false
- Get terms from multiple taxonomies
- Get taxonomy name of current post
- Formating the_terms() function output
- get_terms() returns an empty array
- wp_insert_term auto unique name
- get_terms showing link to category even if all posts are drafts
- Determine if Term has Grandparent/Great-Grandparent
- Custom Taxonomy Only Showing Top Level Terms in Admin?
- Dropdown: Display terms from B only if has relationship with a term A selected
- Get terms of posts with category with sql
- Non-hierarchical custom taxonomy using checkboxes on edit-screen -> saving issue
- Retrieving custom taxonomy in order, but excluding specific tax IDs
- wp_get_object_terms – How can I order the resulting array by hierarchy?
- Get main parent categories for a product
- Get current term’s ID
- Is it possible to get a Previous/Next Taxonomy term archive URL?
- Showing posts by collection of specific terms and texonomy
- get taxonomy terms for parent and child
- Taxonomy query for children of parents
- show term description instead of list terms of custom taxonomy
- WP_insert_term how to insert multiple values as taxonomny term?
- Looping Through Custom Tax Terms and Displaying All Posts For Each
- Group posts that matches a term in a loop
- term_link() filter or rewrite and howto?
- How to get the top most term (top ancestor) of a custom taxonomy child term?
- Display Custom Taxonomy Terns ordered by meta_value
- Separator for multiple terms
- Contact Form 7 – Populating dropdown list with terms relative to the post
- Custom Taxonomy terms with latest post ordered by date pagination issue
- How to set hierarchical terms to a post using wp_set_object_terms
- Echo taxonomy term meta on author.php
- get_the_term_list without specific category
- Hierarchical display of custom taxonomy
- Listing child terms of parent term
- Display the taxonomy name of the current term
- Custom taxonomy term as class?
- How to edit/remove a term that’s in multiple taxonomies?
- Ordering Posts with Custom Taxonomy Terms Array
- How to create a theme template for the taxonomy “root”
- How to display term description in empty terms archive?
- Advanced custom fields – taxonomy terms images [closed]
- Checking if a Page has an Associated Term?
- Custom taxonomy term in WooCommerce product permalink
- What are terms and taxonomy, how they related to post and how these three are stored in database?
- Get multiple term objects by ids
- Automatically assign taxonomy term if custom meta value exists
- List only first-level children of specific custom taxonomy term
- Echo custom taxonomy term name
- get_terms of post->id
- How to handle “the_terms” inside loop
- get_terms custom order
- Display the Terms from a Custom Taxonomy Assigned to a Post(inside the loop) in Hierarchial Order
- How to create drop down for child categories of current taxonomy being viewed?
- Edit post meta with checkboxes on front end
- Limits amount of terms displayed? Is it possible?
- Dynamically tax_query terms
- get / list categories and counts filtered by custom taxonomy term
- How to get a list of taxonomy terms which are being used only within certain post types?
- how to create a proper query for getting a list of users with taxonomy related meta key