Saturday 3 February 2018

Set only first letter capital other in lowercase in PHP SQL

$sql = "SELECT concat(left(emp_name,1),substring(lower(emp_name),2)) as emp_name FROM employee";

Input    : "Raj Kumar"
Output : "Raj kumar"