There are at least 2 ways which I know of.
Select column1, column2 from tableName where column1 <> ''
Remember, use single quotes, not double quotes!
Select column1, column2 from tableName where datalength(column1) > 0
Advertisements
Personal Tech . How To . Tips . Web. Development
There are at least 2 ways which I know of.
Select column1, column2 from tableName where column1 <> ''
Remember, use single quotes, not double quotes!
Select column1, column2 from tableName where datalength(column1) > 0
Let’s say you have a xml file which looks like:
<keywords> <keyword> <title>Business Blogging</title> <date>2009-12-31</date> </keyword> <keyword> <title>Insurance Quotes</title> </keyword> </keywords>
And you want apply some logic based on whether the xml node keywords->keyword->date exist. So how would you do it?
[Read more…]