query database

[Anon]

I've these list of movies. I want to cut them in 3 parts. One with names starting from A-h, another I-R and last one in S-Z. How to query databse for that, i.e.
$sqlstr="SELECT ????";
so that only names starting from A-H is shown???Plz help

[[deleted]]

You may want to flick through the MySQL manual.

Read about the LIKE statement.

[sid666]

i guess you shoudl try it with a groub by startement or so - i really start to hate sql...

[Anon]

I had a look at using Like and was unable to see how you coud do it unless this format is valid

select * from table where left(field1,1) LIKE '[A-H,a-h]'

So, I suggest you try this

select * from table where upper(left(field1,1)) between 'A' and 'H'

That should work, but I;ve not tried it.

John

[[deleted]]

"i really start to hate sql"

if you start to hate SQL then you do not understand it 🙂

[[deleted]]

My reply about LIKE was a bit premature.
this works better
SELECT * FROM table WHERE LEFT(field,1) IN ('a','b','c','d','r','f','g','h','i')

UPPER is not required because MySQL is not case-sensitive by default.

[sid666]

"if you start to hate SQL then you do not understand it 🙂"

exactly my point ;-)

especially since i have a shitload of programs to write and exams to pass about it at the moment...

[[deleted]]

then you have a load of relatively easy exams ahead :-)