SQL again...

mintedjo · 09-18-2008

Hello....
I dont expect an immediate response to this as i've noticed programming questions seem to take a while to get answered. I'll probbaly find a way around this soon enough but anyways:

I have a table with some fields that almost match

myTable(id, field_a, field_x, field_p)

How can i select all the fields which start with "field" ?

In the actual table there are more like 70 fields that fit the similar name thing so typing them all out isnt ideal. Any input is appreciated :-D

DIIRE · 09-20-2008

Have you tried to make a query with all the fields you want then
select * from queryname - atleast you'd only have to type it all the once if you need to use it frequently.

I haven't had to use SQL in over 3 years - hopefully someone else here will have a better idea.

09-18-2008	#1
mintedjo Silver Member Join Date: Sep 2006 Posts: 188	SQL again... Hello.... I dont expect an immediate response to this as i've noticed programming questions seem to take a while to get answered. I'll probbaly find a way around this soon enough but anyways: I have a table with some fields that almost match myTable(id, field_a, field_x, field_p) How can i select all the fields which start with "field" ? In the actual table there are more like 70 fields that fit the similar name thing so typing them all out isnt ideal. Any input is appreciated :-D __________________ teh 1337 j03

09-20-2008	#2
DIIRE Tech Support Team Join Date: Jan 2008 Posts: 2,362 PC Experience: Very Experienced	Re: SQL again... Have you tried to make a query with all the fields you want then select * from queryname - atleast you'd only have to type it all the once if you need to use it frequently. I haven't had to use SQL in over 3 years - hopefully someone else here will have a better idea.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode