SQL SELECT WHERE NOT EQUAL

Question

I'm trying to SELECT from usr_uploaded_content WHERE the id is NOT equal to $content_id I'm just wondering how this could be achieved. Thankyou.

 SELECT * FROM `usr_uploaded_content` WHERE `id` != '$content_id' LIMIT 2

In this example I used the != to demonstrate the not equal.

Also tag dbms! (Perhaps MySQL?) – jarlh Jun 01 '16 at 12:51 — jarlh, Jun 01 '16 at 12:51

score 3 · Accepted Answer · edited May 23 '17 at 11:53

3

Try <>. See Here for more detail

SELECT * FROM `usr_uploaded_content` WHERE `id` <> '$content_id' LIMIT 2

edited May 23 '17 at 11:53

Community

1
1

answered Jun 01 '16 at 12:53

Vinie

2,983
1
18
29

beat me by 8 sec ^.^ – Stivan Jun 01 '16 at 12:54
1

@Vinie, could you please add [this](http://stackoverflow.com/a/723426/1322150) link to your answer? – tsg Jun 01 '16 at 12:56

score 1 · Answer 2 · answered Jun 01 '16 at 12:53

1

SELECT * FROM `usr_uploaded_content` WHERE `id` <> '$content_id' LIMIT 2

answered Jun 01 '16 at 12:53

Stivan

1,128
1
15
24

SQL SELECT WHERE NOT EQUAL

2 Answers2