Untitled

mail@pastecode.io avatar
unknown
mysql
2 months ago
265 B
5
Indexable
Never
SELECT 
    serialnumber, product, size, bin, location, previousbin, previouslocation
FROM
    inventoryitem
WHERE
    (product LIKE '%-_S%'
        OR product LIKE '%-_D%')
        AND location like '7-%'
        AND previouslocation like '7-T%'
        limit 80
	
Leave a Comment