Method Mysql.SqlTable()->select1()
- Method select1
array select1(string|array select_expr, string|array where, void|string table_refs, void|string|array rest, void|string select_flags)
- Description
Convenience variant of select for retrieving only a single column. The return value is an array containing the values in the select_expr column.
- Parameter select_expr
The field to retrieve. It may name a column or a property, or it may be a select expression like "SHA1(x)". It may be given as an array to use bindings or
sprintf
-style formatting - see handle_argspec for details.- Parameter where
The match condition, on the form of a WHERE expression. A WHERE clause will always be generated, but you can put e.g. "TRUE" in the match condition to select all records.
where may be given as an array to use bindings or
sprintf
-style formatting - see handle_argspec for details.- Parameter table_refs
Optional other tables to join into the SELECT. This is inserted between "FROM table" and "WHERE".
- Parameter rest
Optional clauses that follows after the WHERE clause, e.g. ORDER BY, GROUP BY, and LIMIT. It may be given as an array to use bindings or
sprintf
-style formatting - see handle_argspec for details.- Parameter select_flags
Flags for the SELECT statement. If this string is given, it is simply inserted directly after the "SELECT" keyword.
- Returns
Returns an array with the values in the selected column. If a property is retrieved and some rows don't have the wanted property then UNDEFINED is put into those elements.
- See also