Excluding the word "the" in a mysql query

[Dillenger]

Hello,

I'm trying to have a list where you click on a letter in the alphabet and it displays all rows that start with that letter. My problem is some rows have "The" as the start of the record. I want to be able to omit "The" so that if its "The Biscuit Shop" it will show up under "B".

This is my query so far:

SELECT * FROM listings WHERE listingName LIKE '$_GET[action]%' AND listingActive = '0'

How can I modify this to omit the word "The"?:eek:

[Piranha]

First you should read up on SQL injection, the way you use variables are very dangerous. When that is fixed I will give my advice to your question.