Show all records except a few in MySQL

Question

I want to ask how to display all records except for TRX0613-021 Here's is my table

So I need to know how to do that for my assignment.

"Display data in the transaction details table whose transaction ID is not TRX0613-021"

What have you tried so far? Where are you stuck? And how is this related to PHP? — Nico Haase, Apr 27 '21 at 08:38

score 1 · Accepted Answer · answered Apr 27 '21 at 08:30

1

You could use the SQL <> ("not equal to") operator, i.e.

SELECT *
FROM table_name
WHERE id_transaksi <> 'TRX0613-021'

answered Apr 27 '21 at 08:30

score 0 · Answer 2 · answered Apr 27 '21 at 08:30

0

 SELECT ID_TRANSAKSI,ID_BARANG,JML
    FROM YOUR_TABLE WHERE ID_TRANSAKSI<>'TRX0613-021';

answered Apr 27 '21 at 08:30

Sergey

score 0 · Answer 3 · answered Apr 27 '21 at 08:36

You could use any of the following :

SELECT *
FROM table_name
WHERE id_transaksi <> 'TRX0613-021'

OR

SELECT *
FROM table_name
WHERE id_transaksi != 'TRX0613-021'

The queries return all the data in table except the row where id_transaksi is TRX0613-021

Please read more about using != and <> on this post

3 Answers3