我想在laravel上使用LEFT的第一个字符

Question

Maybe anyone can help me?

This is my controller.

$takegolongan = Pekerjaan::select ('LEFT('golongan_jabatan', 1)')->where('cno', '00001222')->get();

echo $takegolongan;

This is the data that I want to take :

output on the screen (error):

Answer 1

You should add single quote inside the double quote or you should use backslash, I can only see the issue of quotes. Like:

    $takegolongan = Pekerjaan::select ("LEFT('golongan_jabatan', 1)")->where('cno', '00001222')->get();