Wierd SQL please

[jamesm87]

Hi,

I have a MySQL db with thousands of tables. All the tables are sorted like this

username_*

Example = jamesm_phpbb_users

Is there a SQL query that will get all the usernames? I did keep a log untill that log database got deleted.

Thanks in advance,

Kind Regards,

James Parmee Morris

[tsinka]

Hi,

write a little script that connects to the database and execute

SHOW TABLES

Then fetch the records and use e.g. strtok to get the username part of each table name.

Thomas

[mourisj]

tsinka wrote:

write a little script that connects to the database and execute

SHOW TABLES

There is a PHP function to do that job :

$list = mysql_list_tables(your_db);

From the PHP manual:

mysql_list_tables() takes a database name and returns a result pointer much like the mysql_db_query() function. The mysql_tablename() function should be used to extract the actual table names from the result pointer.

[tsinka]

Hi mourisj,

thanks for pointing that out 🙂

I just forgot that this function exists.

Thomas