そのうち忘れそうなのでメモ。 $record=mysql_query("SELECT * FROM tablename WHERE time='{$variablename}'"); とか、 $record=mysql_query("SELECT * FROM tablename WHERE (time LIKE '%{$variablename}%')");