How to use Mysql function?

[eluser]suba[/eluser]
Dear all,
I want to use MySql function in select function such as DATE_FORMATE(),CONCAT_WS(),etc.,.

Code:

$this->db->select("filed1,field2");

here how can I use mysql function. But tried like this

Code:

$this->db->select("CONCAT_WS(' ','file_name','name') as name ,filed1,field2");

But shows error message.

please advise me.

Thanks.

[eluser]danmontgomery[/eluser]
http://ellislab.com/codeigniter/user-gui...tml#select

Code:

$this->db->select("CONCAT_WS(' ','file_name','name') as name ,filed1,field2", FALSE);