sql select with column name like

by

This will get you the list

select * from information_schema.columns 
where table_name="table1" and column_name like 'a%'

If you want to use that to construct a query, you could do something like this:

declare @sql nvarchar(max)
set @sql="select "
select @sql = @sql + '[' + column_name +'],'
from information_schema.columns 
where table_name="table1" and column_name like 'a%'
set @sql = left(@sql,len(@sql)-1) -- remove trailing comma
set @sql = @sql + ' from table1'
exec sp_executesql @sql

Note that the above is written for SQL Server.

More Related Contents:

  1. Get Parent with multiple children in desc order
  2. Aggregate columns with additional (distinct) filters
  3. Convert Month Number to Month Name Function in SQL
  4. How to avoid the “divide by zero” error in SQL?
  5. How do I do top 1 in Oracle? [duplicate]
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Using an ORM or plain SQL? [closed]
  8. Removing leading zeroes from a field in a SQL statement
  9. Database Structure for Tree Data Structure [closed]
  10. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  11. sql ORDER BY multiple values in specific order?
  12. Dynamic SELECT TOP @var In SQL Server
  13. MySQL’s now() +1 day
  14. Can you access the auto increment value in MySQL within one statement?
  15. Generate script in SQL Server Management Studio
  16. Oracle SQL – Identify sequential value ranges
  17. ColdFusion adding extra quotes when constructing database queries in strings
  18. In SQL, is UPDATE always faster than DELETE+INSERT?
  19. How can I determine the status of a job?
  20. MySQL #1140 – Mixing of GROUP columns
  21. How can I select rows with most recent timestamp for each key value?
  22. postgresql – sql – count of `true` values
  23. unpivot with dynamic columns plus column names
  24. PostgreSQL where all in array
  25. Converting Select results into Insert script – SQL Server
  26. Is it possible to execute a text file from SQL query?
  27. How to compare dates in datetime fields in Postgresql?
  28. Historical / auditable database
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment