PHP MYSQL: Search Multiple Columns Using Like

I had encountered searching multiple columns using a single input control, a textbox. That is searching from a last name and first name column using any of the two. So I have here the code to do that.
Table

STUDENT

MySQL Code

SELECT * FROM `student` WHERE CONCAT(stud_first,stud_last) like "%ua%"

The query above will search for first name or last name with "ua".

Output

PHP MYSQL: Search Multiple Columns Using Like

PHP MYSQL: Search Multiple Columns Using Like 2016-01-22T06:36:00-08:00 Rating: 4.5 Diposkan Oleh: Emoblazz