|
|
 |
|
|
Thread Tools | Display Modes |
May 21st, 2008, 7:03 AM
|
#1 |
|
Programmer
Join Date: Sep 2004
Posts: 47
Rep Power: 0
 |
SQL - Getting tables in a like
I have some tables that have prefixes like WRT_(WRT_0201, WRT_0202, WRT_0203). I need help in how to get data from the tables that are for example like 'WRT_%' and are in a specific date range (all the tables have the same columns including the date)
Is this possible? Or a workaround? Thanks |
|
|
|
May 21st, 2008, 12:44 PM
|
#2 |
|
Hobbyist Programmer
Join Date: Mar 2005
Posts: 227
Rep Power: 4
|
Re: SQL - Getting tables in a like
Probably depends on the Database type, in DB2 you could goto the SYSIBM.SYSTABLES table (think that's what it's called) in SqlLite there is a query to find tables that are named like something... so I think it is doable, ugly, but doable.
|
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help with sql connection | ghg5 | C# | 1 | May 19th, 2008 2:00 PM |
| SQL Problem | Shivan | PHP | 2 | Feb 29th, 2008 9:43 PM |
| Linking Database Tables | ReggaetonKing | Coder's Corner Lounge | 4 | Jan 23rd, 2008 7:56 AM |
| SQL: Rewrite a complex join without #temp tables? | jonyzz | Other Scripting Languages | 1 | Sep 5th, 2007 10:51 AM |
| Using tables with css | dmorales | HTML / XHTML / CSS | 17 | Apr 13th, 2005 11:01 PM |
Linear Mode
