Using Mysql Select Statement

[Anon]

I am using a select statement to get my data from a table. if i have five names i am selecting such as:

John
Charles
Frank
Fran
Jane

I want to select all the names EXCEPT Jane, what command do i use

In English, this is what i want

$sql = "Select name from $table_name BUT DON'T SELECT Jane";

Thanks for any help

[[deleted]]

Manuals are your friend, I suggest you spend some time in the MySQL manual reading about the SELECT syntax.

SELECT name FROM table WHERE name <> 'Jane';