possible to create sql query with table wildcards?
- by Rees
this is probably a simple question, but i have been unable to find a solution online, any help would be much appreciated.
I'm trying to create an SQL query in PHP and would like to somehow apply a wild card to the TABLE filter... something perhaps like.... select * from %table%. However, I have only so far been able to see filters for column values not table names.
as an example i would have tables such as:
jan_table_1
feb_table_1
jan_table_2
feb_table_2
and would want to say, select only tables with a "jan" prefix... or "1" suffix.
Is there a quick and easy solution to this that I have not seen? Thanks in advance!