Hello
I have this table named works:
Code:
employeeName companyName salary
Brian Jørgensen First Bank Corporation 600000
Joe Santana First Bank Corporation 500000
Kim Wild First Bank Corporation 400000
Gino Mohammed We Do PHP 100000
Søren Petersen We Do PHP 300000
Hanne Jørgensen We Do PHP 100000
John Rambo We Do PHP 20000
Mathias Hansen All Of Java 150000
I want to find the names of all employees who work for First Bank Corporation.
For this i made this query in mysql:
SELECT `employeeName`
FROM `mhha_Assignment2`.`works`
WHERE `companyName` LIKE `First Bank Corporation`;
I get this error:
Error Code: 1054
Unknown column 'First Bank Corporation' in 'where clause'
Can anyone explain me what is wrong?
Thanks