CODEWITHSUNDEEP
phptypo3
user2294256
user2294256

Reputation: 1049

issue with exec_SELECTquery() in typo3

$res = $DB->exec_SELECTquery('uid, image', 'fe_users', 'image<>\'\'');

I saw it from one script, and I know the syntax:

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($select_fields,$from_table,$where_clause,$groupBy,$orderBy,$limit);

but still wonder :what does this mean?: 'image<>\'\''

Upvotes: 0

Views: 212

Answers (1)

Jay Harris
Jay Harris

Reputation: 4271

where the image column is not empty

<> greater than and less than sign means not equal to <> is the same as !=

'' empty single quote is exactly what the name is, empty

\ the backslashes escapes the single quotes so this , "image <> '' "); would also work

put it together, that part of the statement means 

  WHERE `image` <> ''

or

  WHERE `image` != ''

MYSQL Comparison Functions and Operators

Upvotes: 1

Related Questions