title: Select all except one field in SQL
body: <p>I would like to create a function which select all the characters with their properties in the db except the one who execute this function and because I'm new with SQL, I'm wondering if there was a way to do that : <code>SELECT * FROM 'table name' EXCEPT 'the character executing the function'</code>.</p>
  
  <p>For example, if a player in a rpg game wants to attack someone, I would like to put the whole list of other players in the database that he can attacks. But if I do <code>SELECT * FROM 'table name'</code>, he will be in the list and I don't want him to attack himself...</p>
  
  <p>I search on Google and here but I only found solution for selecting all except a column, but i want that for a field.</p>
  
  <p>Thanks for reading.</p>