#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    2
    Rep Power
    0

    Question SQL Select statement


    I want to select all fields from my SQL table apart from one. Does anybody know of a way i can select all fields apart from one, or two, or three?

    Or do you have to enter a full select statement as in select field1, field2, field3, field4 etc etc from tbltable.

    I have about 40 fields in a table and just want to select certain ones without making a view.

    Thanks for you help in advanced
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Posts
    5
    Rep Power
    0
    Well to the best of my knowledge (which is exceedingly limited) unless you use "select *" then you're gonna have to enter every field.

IMN logo majestic logo threadwatch logo seochat tools logo