Hi,
CREATE TABLE IF NOT EXISTS media(
id INT UNSIGNED NOT NULL AUTO_INCREMENT,
contestant_id INT UNSIGNED NOT NULL,
title VARCHAR(255) NOT NULL,
description VARCHAR(65535) DEFAULT NULL,
uid VARCHAR(255) NOT NULL,
published DATETIME NOT NULL,
visible TINYINT(1) DEFAULT 0 COMMENT '1 yes 0 no',
iswinner tinyint(1) DEFAULT 0 COMMENT '1 yes 0 no',
PRIMARY KEY (id),
UNIQUE KEY unique_media_uid (uid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
can anyone explain me why on earth with this query
SELECT *
FROM `media`
WHERE uid =0
I get data ?
in uid field I’ve got data like
kHnn67 the youtube watch id.
Thanks in advance.