/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 vote198 views1 answer
List mysql tables and views
SQL
0 vote193 views1 answer
What is the use of index in mysql table
SQL
2 votes193 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote197 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote217 views2 answers
Create table if not exist
SQL
0 vote203 views1 answer
How to join result table in mysql
SQL
1 vote200 views1 answer
Vagrant mysql downgrade version
SQL
9 votes178 views1 answer
Mysql check date range
SQL
0 vote198 views1 answer
Rename view mysql
SQL
0 vote193 views2 answers
Psql commande \gset
SQL