MySql Query to Concatenate Fields

See more:

MySQL

Hi All,

I have a Employee details in my database their name are given in the
field(firstname,middlename,lastname). when i try to fetch the employee details by their name .

Select * From Employeedetails where
Concat(firstname,'',middlename,'',lastname)='Maria Francis Desosa'

It Works Fine

When i try to fetch Employee who does not have middle name it return zero. so i try


Select * From Employeedetails where
Concat(IFNULL(ER.firstname,' '),' ',IFNULL(ER.middlename,''),'',IFNULL(ER.lastname,'')
='Maria Desosa'

Still this not getting the data. can any body know how to retrieve the data who does not have middlename

Thanks
parithi