Tommy Barrios wrote:
Using the below statement results in a null data dump:
SELECT * FROM items WHERE item = '109S2' AND venturi_type = 'L-shaped' AND category = 'burner';
Whereas if change the 'S' in the item = 10902 like this:
SELECT * FROM items WHERE item = '10902' AND venturi_type = 'L-shaped' AND category = 'burner';
I get a full complete data dump. Both numbers are legitimate part numbers in the item column yet one works the other does not.
Apparently you have no rows where all three criteria are true. If you think you do, you need to examine the values in the table more carefully. Perhaps the item value has a newline at the end or a space at the beginning or something else not immediately visible. Try selecting LENGTH() or HEX() of a column to see whether it's what you expect.
-- Keith Ivey <[EMAIL PROTECTED]> Smokefree DC http://www.smokefreedc.org Washington, DC
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
