michaellunsford Posted May 10, 2006 Share Posted May 10, 2006 ran through the refman without much luck -- I just don't know what to search for. I found something in the PHP manual as a starting point "SQL SHOW TABLES" but I don't want to parse through a long list of table names -- just see if a very specific table name exists. Any ideas?Thanks! Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/ Share on other sites More sharing options...
ryanlwh Posted May 10, 2006 Share Posted May 10, 2006 try [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--]SHOW TABLES [color=orange]LIKE[/color] [color=red]'table_name'[/color] [!--sql2--][/div][!--sql3--]If table_name doesn't exist, it will return empty set. Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/#findComment-35047 Share on other sites More sharing options...
michaellunsford Posted May 15, 2006 Author Share Posted May 15, 2006 Thanks. got it working. Link to comment https://forums.phpfreaks.com/topic/9494-does-this-table-exist/#findComment-35941 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.