> ## Documentation Index
> Fetch the complete documentation index at: https://docs.xano.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Get Record
Get Record allows you to retrieve a single record from a database table using a single field to search by.
In Get Record, you'll provide the name of the field to search inside of, and the value to search for. These can come from inputs, variables, or you can manually specify a value.
**field\_name** is the name of the field to look inside of. For example, if we wanted to search for a record with a specific ID, we'd type `id` here.
**field\_value** is the value to search for in the provided field. Assuming we are searching in the `id` field, we would put the ID to search for here.
If you need to find a record based on multiple fields, use [Query All Records](/the-function-stack/functions/database-requests/query-all-records) instead.
You can also choose to enable a lock on the returned records here. Locking the records as part of a [database transaction](/the-function-stack/functions/database-requests/database-transaction) will prevent other function stacks from modifying the data until the lock has been released.
### Customizing the return
Click 
to edit the fields returned in the query.
Note that customizing to reduce the fields returned will not have an impact on query speed, but may help with other performance issues in your function stacks. It is always good practice to only return the fields necessary.
### Return As
Change the variable name that this function will output to.
If you're using conditional steps, you can use the same variable name in multiple steps to make satisfying the conditional or outputting data in the response easier.
For example, if we are sending a specific response based on if a variable is true or false, we can set both of those outputs to the same variable, making building our response easier.
Give this function a description for easy understanding of what this function achieves.
This description will appear in the function stack, giving you easier readability for complex logic.
