in reply to Re^2: DBI selectall_arrayref
in thread DBI selectall_arrayref

Not when inside another string. Backticks (and/or square brackets) are quotes for SQL barewords:
"SELECT COL1,COL2 FROM TABLE"
and
"SELECT `COL1`,`COL2` FROM `TABLE`"
are equivalent. It allows you to have columns with whitepace in the name:
"SELECT `COL1 NAME`,`COL2 NAME` FROM TABLE"

"SELECT 'COL1 NAME','COL2 NAME' FROM TABLE"
would return something entirely different.

Replies are listed 'Best First'.
Re^4: DBI selectall_arrayref
by davido (Cardinal) on Sep 02, 2004 at 16:14 UTC

    :) Learn something new every day. Thanks ikegami. I guess I should have referred to the SQL manual before jumping to conclusions.


    Dave