DROP INDEX.. what if there is no index?

[ppowell]

ALTER TABLE image DROP INDEX ix_search;

The above-mentioned SQL statement will produce an error if the index ix_search does not exist.

How can I check to see if the index exists before I drop it; and to ensure the ALTER TABLE statement is never invoked to drop the index if there is no index to drop?

I am created a reusable SQL file that will be shipped with a portable PHP-based web application.

Thanx
Phil

[AtroZ]

$conId = mysql_connect("host","user","password");

$db = mysql_select_db("db_name",$conId);

$sql = "show index from table_name";

$result = mysql_query($sql,$conId);

while($row = mysql_fetch_assoc($result))
{
	// The name of the index will be in "Column_name" 
	if($row["Column_name"]=="index_you_are_searching") $idx_exists=true;
}

if($idx_exists)
{
	// Dropping stuff
}
else
{
	// plan B?
}

[ppowell]

Thanx but I can't use a PHP solution for this as this directly connects to the MySQL engine to run this SQL script. 🙁

Phil