We help IT Professionals succeed at work.

Can't select record on a certin Field.

teksavers
teksavers asked
on
298 Views
Last Modified: 2012-05-05
My question is this, I am doing a simple Select in a table against the product field. I cannot get any returns when I know that the record is there. I can do the same query against the productid field and get a result. Not sure what I am doing wrong.

SELECT * FROM `xcart_products` WHERE `product` LIKE "VWIC-1MFT-E1"
MySQL returned an empty result set (i.e. zero rows). (Query took 0.2667 sec)
But its there...
Here is the Table:
CREATE TABLE IF NOT EXISTS `xcart_products` (
  `productid` int(11) NOT NULL auto_increment,
  `productcode` varchar(32) NOT NULL default '',
  `product` varchar(255) NOT NULL default '',
  `provider` varchar(32) NOT NULL default 'master',
  `distribution` varchar(255) NOT NULL default '',
  `weight` decimal(12,2) NOT NULL default '0.00',
  `list_price` decimal(12,2) NOT NULL default '0.00',
  `descr` text NOT NULL,
  `fulldescr` text NOT NULL,
  `avail` int(11) NOT NULL default '0',
  `rating` int(11) NOT NULL default '0',
  `forsale` char(1) NOT NULL default 'Y',
  `add_date` int(11) NOT NULL default '0',
  `views_stats` int(11) NOT NULL default '0',
  `sales_stats` int(11) NOT NULL default '0',
  `del_stats` int(11) NOT NULL default '0',
  `shipping_freight` decimal(12,2) NOT NULL default '0.00',
  `free_shipping` char(1) NOT NULL default 'N',
  `discount_avail` char(1) NOT NULL default 'Y',
  `min_amount` int(11) NOT NULL default '1',
  `dim_x` int(11) NOT NULL default '0',
  `dim_y` int(11) NOT NULL default '0',
  `dim_z` int(11) NOT NULL default '0',
  `low_avail_limit` int(11) NOT NULL default '10',
  `free_tax` char(1) NOT NULL default 'N',
  `product_type` char(1) NOT NULL default 'N',
  `manufacturerid` int(11) NOT NULL default '0',
  `return_time` int(11) NOT NULL default '0',
  `keywords` varchar(255) NOT NULL default '',
  `cond` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`productid`),
  UNIQUE KEY `productcode` (`productcode`,`provider`),
  KEY `rating` (`rating`),
  KEY `add_date` (`add_date`),
  KEY `provider` (`provider`),
  KEY `avail` (`avail`),
  KEY `best_sellers` (`sales_stats`,`views_stats`),
  KEY `categories` (`forsale`),
  KEY `fi` (`forsale`,`productid`),
  KEY `fia` (`forsale`,`productid`,`avail`),
  KEY `ppp` (`productcode`,`provider`,`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=90810 ;


not sure what I am doing wrong.
Comment
Watch Question

Top Expert 2007
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.