Selecting all columns that start with XXX using a wildcard?

by

You’d have to build the SQL dynamically. As a starting point, this would get you the column names you’re seeking.

SELECT COLUMN_NAME
    FROM INFORMATION_SCHEMA.COLUMNS
    WHERE table_name="Foods"
        AND table_schema="YourDB"
        AND column_name LIKE 'Vegetable%'

More Related Contents:

  1. How can I properly use a PDO object for a parameterized SELECT query
  2. MySQL: Select Random Entry, but Weight Towards Certain Entries
  3. Notice: Array to string conversion in
  4. SELECT COUNT() vs mysql_num_rows();
  5. Select from mysql table WHERE field=’$array’?
  6. unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING error [duplicate]
  7. How do I set the selected item in a drop down box
  8. Selecting all fields except only one field in mysql [duplicate]
  9. select within 20 kilometers based on latitude/longitude
  10. MySQL ORDER BY rand(), name ASC
  11. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  12. How to properly set up a PDO connection
  13. Using PHP 5.5’s password_hash and password_verify function
  14. How to do this in Laravel, subquery where in
  15. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  16. Levenshtein: MySQL + PHP
  17. PHP MySQLI Prevent SQL Injection [duplicate]
  18. mysql PDO how to bind LIKE
  19. How to test if a MySQL query was successful in modifying database table data?
  20. How do i “echo” a “Resource id #6” from a MySql response in PHP?
  21. Does mysql_real_escape_string() FULLY protect against SQL injection?
  22. Recursive categories with a single query?
  23. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  24. Password_Hash not working on my PHP login
  25. Select last 20 order by ascending – PHP/MySQL
  26. Formatting an SQL timestamp with PHP
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Backup a mysql database and download as a file
  29. Is a BLOB converted using the current/default charset in MySQL?
  30. PHP/MySQL Pagination

Leave a Comment