select records apart from id=1

[brown2005]

is there away to select all records in a table accept 1 where say

members_id='1'

it will select all records apart from that record

any help will be good?

thanks in advance

[Kano]

select * from table where members_id != '1';

[moore82]

You don't need the ' around the number as it should be saved in your DB as an integer/auto inc. I'm assuming this since the field is called ID