vb.org Archive - MySQL getting not empty rows

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - MySQL getting not empty rows (https://vborg.vbsupport.ru/showthread.php?t=103904)

AN-net

12-28-2005 02:25 PM

MySQL getting not empty rows

how should i go about getting not empty rows for a particular field/column? should i use foobar!='' or something else?

Marco van Herwaarden

12-28-2005 03:04 PM

Dependinng on the contents of the 'empty' columns (i guess you want to retrieve the content of the rows that have a value for a certain column), it would be either:
- column <> ''
- column <> 0
- column IS NOT NULL

AN-net

12-28-2005 03:16 PM

ok thanks
edit:
the type of column is varchar, it seems to be yielding no results...but i know that some of them are empty.

the sql query i am running is:
[sql]
"SELECT journal_id, whocanview FROM " . TABLE_PREFIX . "journals WHERE whocanview IS NOT NULL"
[/sql]

Marco van Herwaarden

12-28-2005 04:34 PM

does the column allow NULL values, if no, what is the default value.

AN-net

12-28-2005 04:44 PM

Quote:

Originally Posted by MarcoH64

does the column allow NULL values, if no, what is the default value.

how do i know if it does?

Marco van Herwaarden

12-28-2005 04:46 PM

Describe the table, look in phpMyAdmin, look in the scripts that created it.

AN-net

12-28-2005 04:58 PM

under the column labeled "null" it says no for that field so i guess using IS NOT NULL will not work?

Marco van Herwaarden

12-28-2005 05:02 PM

Correct, the column will then contain the default value.

try with: column <> ''

AN-net

12-28-2005 05:06 PM

Quote:

Originally Posted by MarcoH64

Correct, the column will then contain the default value.

try with: column <> ''

that worked ty, your da best:D

Marco van Herwaarden

12-28-2005 05:08 PM

I know. ;):D:D:D

All times are GMT. The time now is 07:24 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01088 seconds Memory Usage 1,724KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: