MySQL Forums
Forum List  »  Newbie

Why is this Select not working
Posted by: Florian Machka
Date: March 25, 2017 08:49AM

Hello,

why is this Select not working?

SELECT
COUNT(*) AS expr1
FROM tbl_catalog_movies
WHERE tbl_catalog_movies.filename = 'Pay Day.mkv'
AND tbl_catalog_movies.directory = '\\192.168.2.199\mediaserver-disk-1\Video\Filme\Stummfilme\Charlie Chaplin\Kurzfilme'
AND tbl_catalog_movies.filesize = 298817597

The Table looks like this:
The "Filename" and "Direcotry" Columns are VARCHAR(255) and the "Filesize" Column is a BIGINT(20)

In this Table, the record I want to select exists four times, but the result "expr1" is always 0. Why?

Thank you in advance for your help.
FloMac

Options: ReplyQuote


Subject
Written By
Posted
Why is this Select not working
March 25, 2017 08:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.