[SOLVED] Help with a Query

[JSHINER]

I have this:

 

"SELECT count(*) FROM table WHERE id = 2"

 

I would also like to add the condition that if name is NOT blank - I tried "AND name != but that did not work. How can I do this, so it only displays results where name has a value?

[trq]

SELECT count(*) FROM table WHERE id = 2 && name <> NULL

[JSHINER]

That does not return any results. When I did:

 

SELECT * FROM table WHERE id = 2 AND field_2 ORDER BY id

 

It returns only records where field_2 is filled, however ONLY records where field 2 is filled with a number.

 

How can I get it so if field_2 has ANYTHING there it returns it?

[JSHINER]

Sorry - Figured it out.

 

SELECT * FROM table WHERE id = 2 AND field_2 != '' ORDER BY id