[eluser]Unknown[/eluser]
I have table prefix "ds_". When I execute this query:
Code:
$this->db->select('concat(id, ".") as id_dotted')
->where('parent < 10')
->get('categories AS c');
result is:
Code:
SELECT concat(c.path, `ds_"`.`")`
FROM (`ds_categories` AS c)
WHERE `parent` < 10
Naturally query don't work because dot is displayed (... `ds_"`.`")`.
This is a problem.
Do you have a solution?
Thanks.