The MySQL first() function returns the first value from specific field with the help of
LIMIT clause to select first record. It is used when you need to get first record from fields value.
To find very first record from specific field in a table, use the following syntax:
tablename: The table name from which you want to fetch records.
col1: The column or field name that will be return.
In the above example, we are fetching first record from column "firstName" in tblCustomerLoan" table.
You can use MySQL Command Line Client to find first record from the specified fields in the table. It will look like this: