Solar_Sql_Adapter_MysqlReplicated::quoteNamesIn()

public string|array Solar_Sql_Adapter_MysqlReplicated::quoteNamesIn ( string|array $spec )

Quotes all fully-qualified identifier names ("table.col") in a string, typically an SQL snippet for a SELECT clause.

Inherited from Solar_Sql_Adapter.

Parameters

  • (string|array) $spec: The string in which to quote fully-qualified identifier names to quote. If an array, quotes names in each element in the array.

Returns

  • (string|array) The string (or array) with names quoted in it.

Description

Quotes all fully-qualified identifier names ("table.col") in a string, typically an SQL snippet for a SELECT clause.

Does not quote identifier names that are string literals (i.e., inside single or double quotes).

Looks for a trailing ' AS alias' and quotes the alias as well.

See Also



Local