how can i add two strings in Autocomplete label

Question

This is my query of Autocompletion:

$studentsQuery = $conn->query('select s.student_fname,s.student_lname as label,blahhh.....);

from the query i am getting result as student_lname in input field value because i wrote it as a label

My question is how can i add student_fname, student_lname in label..?

Example:
I have a name like Mohammad(student_fname) Waheed(student_lname) current result is "waheed" But i want "Mohammad Waheed".

Answer 1

The concat() function is used to combine multiple strings:

select concat(s.student_fname, ' ', s.student_lname) as label ...