|
如题:
1. select prod_name from products; /*sql语句*/
$this->db->select('prod_name'); /* c i */
$query=$this->db->get('products');
那这些怎么写??
select concat(vend_name,'(',vend_country,')') from vendors order by vend_name;
select prod_id,pro_name from peoducts where prod_name like'j%t';
select prod_id,pro_name from peoducts where prod_name like'_jt';
select prod_name from products where prod_name regexp '1000' order_by prod_name;
$this->db->query('select concat(vend_name,'(',vend_country,')') from vendors order by vend_name;');
帮个忙啦~~~~~~~~~~~ |
|