MySQL Select non alphabetic records

[MrBelfry]

Hey there kids

Is there any way to write a sql statement that extracts all records from a databse that DON'T begin with a letter ie a number or some other character?

Please help me. I'm stupid

Thanks

MrBelfry

 

[hos2]

which records do you want to see when it may not begin with a character ???

 

[MrBelfry]

I have a site that has some album reviews. If a band's name begins with a number then I group them all together. So if I have a band called '216 State' or '1,000 Foot Krutch' or something I would like to group them together on a page where I can see their titles and stuff.

See the site at

http://www.mrbelfry.co.uk/reviewindex.php

for what I'm trying to achieve.

MrBelfry

 

[hos2]

so you group by the first character and make a link that queries with that first character

select distinct(substr(name,0,1)) as shortname from tablename

the result for each you can pass to an url which loads a page that search on that key

search.php?shortname=$shortname

in search.php you have something like

select name from tablename where name like '$shortname%'


if you are not yet familiar in how to write the code than I can help you out later on.

 

[MrBelfry]

Here's how I solved it

SELECT * FROM tablename WHERE fieldname NOT BETWEEN 'a' AND 'z'

MrBelfry