Question About SQL With MySQL

[Anon]

How would you select all that doesnt equal a certain value?

Use the NOT value?

[Anon]

SELECT * FROM table WHERE column != value

[flipis]

or, if you're more VB guy:

SELECT * FROM table WHERE column <> value

fLIPIS

[Anon]

Or (if you have multi values) :
SELECT * from TABLE
WHERE column NOT IN in ("toto", "tutu");

[flipis]

Now, this is what i call A USEFUL command. Never seen it in my MySQL manual. Thanks a lot.

Maybe you know this one (useful for foreing keys):

SELECT customers.id,customers.name,debts.string_to_show,discounts.string_to_show FROM customers INNER JOIN debts ON customers.debt_level = debts.id INNER JOIN discounts ON customers.discount = discounts.id WHERE customers.debt_level = 1 AND discounts.amount = 100

Btw: MySQL before 3.22 doesn't support it. Use LEFT JOIN instead.

fLIPIS

Btw: Anyone knows of a link with advanced SQL tutorials? All i've seen is quite in the style of

SELECT field FROM table