Thank You so much John and Michael. SHOW TABLES LIKE 'a%' worked like a
charm and was exactly what I was looking for. I guess my searches were
using the wrong keywords. Kind of figures. Some of my searches were
turning up 1000's of results.
How do you know whether it's an "active" a* table
> Basically just do a a php script the sends the sql "show tables";
>
> Then do a strchr() to see if "a" is the first letter in the resuts and
if
> so do a delete table.
>
> Just yo play safe do a dump of your db first.
Or even better, use SHOW TABLES LIKE 'a%' to just get the a* tables and
dr
Basically just do a a php script the sends the sql "show tables";
Then do a strchr() to see if "a" is the first letter in the resuts and if so do a
delete table.
Just yo play safe do a dump of your db first.
Cheers,
Mike
*** REPLY SEPARATOR ***
On 29/12/2002 at 7:57
3 matches
Mail list logo
