[thelist] Quick SQL help
Matthew Bernhardt
bernhardt.7 at osu.edu
Wed Mar 1 09:00:45 CST 2006
SELECT * (or field list)
FROM (yourtable)
WHERE Warehouse LIKE 'A*'
The wildcard you use in your WHERE statement will depend on what db you're
using. Access, I think, uses * while MySQL uses %. Check the documentation
for your db.
Hope this helps,
Matt
On Wed, 01 Mar 2006 09:54:01 -0500, Rob Smith <rob.smith at lexjet.com> wrote:
> Hi,
>
> Take a sample order (Order, SKU, Warehouse, Location):
> 1234 ____ ABC ____ A ____ 2
> 1234 ____ ADE ____ C ____ 40
> 1235 ____ EEF ____ C ____ 55
> 1236 ____ EEJ ____ A ____ 1
> 1236 ____ JJK ____ A ____ 1
>
> How do I narrow this list down to show all orders that had at least one
> "A" location in it?
>
> Thanks,
>
>
> Rob Smith
> LexJet
> rob.smith at lexjet.com
> http://www.lexjet.com
> (800)453-9538
> (941)330-1210 Int'l
> (941)330-1220 Fax
> 1680 Fruitville Road, 3rd Floor
> Sarasota, FL 34236
>
> Proud Sponsors of the Professional Digital Imaging Association
> (www.pdia.org)
>
>
--
Matt Bernhardt, bernhardt.7 at osu.edu
Webmaster + Fab Lab Coordinator
Knowlton School of Architecture
The Ohio State University
More information about the thelist
mailing list