SurrealDB Docs Logo

Enter a search query

->select()

Selects all records in a table, or a specific record, from the database.

Method Syntax
$db->select(thing)

Arguments

ArgumentsDescription
thing required

The table name or a RecordId to select.

Example usage

// Select all records from a table
$people = $db->select('person');

// Select a specific record from a table
$person = $db->select(new RecordId('person', 'h5wxrf2ewk8xjxosxtyc'));
$person = $db->select(new StringRecordId('person:h5wxrf2ewk8xjxosxtyc'));

Translated query

This function will run the following query in the database.

SELECT * FROM $thing;

On this page

© SurrealDB GitHub Discord Community Cloud Features Releases Install