How do you write "Select (all) From (table) Where posting=$posting except this posting? (Mysql)
- by ggfan
I want to write a Mysql statement that selects all from a table(posting) where title is like $title except for the title of $title. Basically I want to display all related posting of a certain posting. I want the query to select all the postings in the table that has the title name in the title and detail. But I don't want the posting to display in the related postings.
$query="Select * From posting Where title,detail, like %$title% except $title";
how do I write the except part?