/SQL/Left join in codeigniter query builder

Left join in codeigniter query builder

$this->db->select('p.id, p.photo, p.desc, info.desc');
$this->db->from('products as p');
$this->db->join('lang_info as info', 'info.id=p.id and info.lang='.$this->lang, 'left');
$this->db->where('p.id', $this->product_id);
$this->db->where_in('info.name', ['good', 'bad']);

Similar codes

0 vote227 views1 answer
Sql select column names starting with
SQL
12 votes263 views1 answer
Run mysql instance in docker
SQL
0 vote266 views1 answer
Mysql faster delete
SQL
0 vote231 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote239 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
4 votes252 views2 answers
Mysql alter table set column unique
SQL
2 votes258 views1 answer
Sql find not in list
SQL
0 vote237 views1 answer
Mysql undo delete
SQL
-1 vote187 views3 answers
Ubuntu install mssql
SQL
0 vote242 views1 answer
Sql select random procentage from rows
SQL