Name : filterTable - Language : Sql - type : Select - platform : geniric - tag : filter, table

filterTable.sql

/* Filter table from a database */
/*  see : http://stackoverflow.com/questions/6528531/mysql-show-tables-sort-by-table-name?answertab=votes#tab-top */
/* string $filter = filter */
/* string $dbn = database name */
SELECT table_name
FROM information_schema.tables
WHERE table_type = 'BASE TABLE' AND table_schema='$dbn' AND table_name LIKE '$filter'
ORDER BY table_name ASC;