Member Avatar for Jfunch

What I need to do is search brand names, find all the brands that start with the letters A-E and put those under a header on my webpage. Then search F-O and then P-Z and do the same thing. How would I go about querying the database to get the brands that start with A-E and so on? Ive got a products table with a brands row to help with the query.

  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 3 Hours Discussion Span
  • Latest Post Latest Post by |-|x
Member Avatar for |-|x

There is a function called LEFT which can be used to grab the first letter of a field for comparison

example:

SELECT * FROM tblBrands WHERE LEFT(Brand,1) BETWEEN 'A' AND 'E'

etc...

Edited by |-|x because: formatting
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.