BuddyPress.org

There are already fields for first_name and last_name in wp_usermeta

…

Where is that built-in “name & last name” feature that Nicola Greco mentioned?

The wp_usermeta table actually has four fields, none of which are specifically for first_name or last_name. What you are referring to are data pairs stored between the meta_key and meta_value fields. To extract a first and last name from wp_usermeta, then, requires returning data from two records, not a single record.

An example:

umeta_id       user_id       meta_key      meta_value

22	           1	       first_name	  Myfirstname

23	           1	       last_name	  Mylastname