need help

[[deleted]]

Hello,

I want to list all the databases on my mysql server.

However, I also want to only list selected ones. What I mean is I only want to list databases that start with "myDB"

eg. list of databases

bubble_gum
mytoys
myDB_counter
myDB_search
someDB

it will only list myDB_counter and myDB_search

Please tell me what to use to do this... thanks

[smulpur]

YOu can get a list of databases starting with myDB_ with the following sql.

select * from db where db like 'myDB%'