MySQL / PHP - Display all rows from table except one single row

debugcn Published at Dev

Dan

me again!

So I'm wondering what the sequel/php code is to display all the rows in a table except one row. So display row 1, 2, 3 and 4 and every column, but don't display anything to do with row 5. The reason for this is I want to display all users in a user table except the user that is looking at the list itself.

Checking which user is looking at the list is fine because I can use a variable I set aside called userid which can be used to check it against. I just don't know the SQL terminology I need to use to essentially "select * from table except this row".

Any help please?

damian004

What's wrong with:

SELECT * FROM `table` WHERE `id` <> 5

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-06-29

Comments

0 comments

From Dev

Related Related

Article

MySQL / PHP - Display all rows from table except one single row

MySQL / PHP - Display all rows from table except one single row

PHP MySQL: Display all column names from a given table and the values for any single given row

MYSQL Single query to retrieve both single row from one table and many rows as a single field from another

MySQL query - single row in one table with multiple rows in another table

Taking ids from two rows of one MySQL table and entering those values in one row of another MySQL table using PHP

Delete all Duplicate Rows except for One in MySQL?

MySQL: combine 2 rows from another table into a single result row

Delete all rows, except last 10 for each client that has related row(s) in the table in one query?

MySQL - Exclude all rows from one table if match on another table

Mysql Trigger, Copy All Rows From One Table Into Another Table

How to display one row when table has multiple rows related to Single record in other table?

Mysql - Delete All except 2 rows of all post_id1 from a table

Displaying all the rows from different columns into one single row and single column in sql

asp.net how to remove all the rows from a table except the first one

How to get 2 columns from one table and 2 rows as columns from other table in one row, in MySQL?

how to select one row from one table and multiple rows from other table using joins in mysql,

Display Store Products in Row from MySQL table (PHP)

Retrieve all rows from table except few rows in laravel

Copy only specific rows from one table to another in PHP and MySQL

PostgreSQL for each row from one table join all rows from another table

Delete all rows from MySQL table using PHP

Select all rows from a table except where row in another table with same id has a particular value in another column

Display each row one by one from each category one by one using php mysql

MySQL query to update all "duplicate" rows except the latest one

MySQL query to update all "duplicate" rows except the latest one

How to select data from several rows in a single table in one result row?

How to combine multiple rows from 4 tables into one single row in a new table in SQL?

Display different rows of a record in a single row having all the column values

Dot product of one row against all rows in a many-column mySQL table

Dot product of one row against all rows in a many-column mySQL table