mysql how to select all and exclude one column from table

Asked Feb 05 '15 at 09:04

Active Feb 05 '15 at 09:28

Viewed 898 times

i have a table name users and i want to download to csv file by a query, but i dont want to select a password column in table users.

i am new to sql that to fresher, please any one help me. below is my query

function get_all_partnerships_to_download() {

        $this->db->select('*');
        $this->db->from("$this->_users_table");
        $this->db->join("$this->_user_profile_table",  "$this->_user_profile_table.user_id = $this->_users_table.id");
        $this->db->where("$this->_user_profile_table.participate_as_id", 3);
        $this->db->group_by("$this->_users_table.id");
        $this->db->distinct();

        return $this->db->get($this->_table);

    }

edited Feb 05 '15 at 09:28

coDe murDerer

1,858
4
20
28

asked Feb 05 '15 at 09:04

qwerty

You have to specify column names – M Khalid Junaid Feb 05 '15 at 09:07
Have a look at this SO question http://stackoverflow.com/questions/9122/select-all-columns-except-one-in-mysql – Ma'moon Al-Akash Feb 05 '15 at 09:08
or create a view without password column and select that view in your php :) – Krish Feb 05 '15 at 09:11
What is the password column name? and what table is it in – Matt Feb 05 '15 at 09:18
@M Khalid , no without specifying column names, i thought u asked me to specify in question for your reference – qwerty Feb 05 '15 at 09:19
@qwerty You cant, you cant exclude column names, only specify columns. Post your data structure and someone will write it up for you – Matt Feb 05 '15 at 09:22
@Matt column name is password and table name is user_profile – qwerty Feb 05 '15 at 09:26

mysql how to select all and exclude one column from table

0 Answers0