Need help with a query

[baudits]

Hello

 

I have this table named works:

 

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 `myDB`.`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

[DavidAM]

The literal "First Bank Corporation" needs to be in quotes not back-ticks.

SELECT `employeeName`
FROM `myDB`.`works`
WHERE `companyName` LIKE 'First Bank Corporation';

[baudits]

thanks alot