information_schema
performance_schema
db_214625_1
db_214625_2
db_214625_3
db_214625_4
<?php
/**
* hemiolos.lima-city.de/test/mysql_if.php
*/
$conn = ...; connect to database
$query = <<< EOT
SELECT p.para
FROM (
SELECT @sn:=schema_name,
IF(schema_name LIKE '%schema',
CONCAT('<p style="color:#f00;font-weight:bold;">', @sn, '</p>'),
CONCAT('<p>', @sn, '</p>')
) para
FROM information_schema.schemata
) p
EOT;
$res = mysql_query($query);
while($row = mysql_fetch_object($res)) {
echo $row->para."\n";
}