MYSQL show tables?

[lytheon]

I'm looking for a statement where u can show some tables, (not all)in MYSQL

does anybody know how i can show these tables:
Activiteit
Activiteit_set
Activiteit_set_Activiteit
Afdeling
Bedrijf
BS_AFSPRAKEN
FUNCTIE
MEDEWERKER
MEDEWERKER_CONTRACT
MEDEWERKER_RECHTEN
PROJECT
SCHERM_RECHT
STUURCYCLUS_AS
SYSTEEM
SYSTEMEN_OFFLINE

(note: these ara not all the tables in my database)

hope someone can help me!

with kind regards,

Lytheon

 

[spookie]

U need to use some kind of REGEX.
ie

show tables LIKE regex [regular expression] ;

Not sure how to do it for ur list of tables though.





--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.