Column number in mysql ‘WHERE’ condition

  mysql, php, sql, where-clause

How is it possible to select the first column in the Where clause. I am trying to make a php function to retrieve table data based on the id, yet since the titles of the id columns are different in various tables, I need to refer to the first column in the Where clause as the first column is always the id column.

The scenario would be something like the following, but it throws errors and says that there is an error in the SQL syntax.

$stmt = $this->conn->prepare("SELECT * FROM $table WHERE column(1) = :id");

Thanks in advance.

Source: Ask PHP

LEAVE A COMMENT