Selecting fields question

Sharif

How would I go on about selecting fields where the fields start with numbers or symbols (!@#$%^&*)? I was told to use REGEXP but just can't figure out how to get it work with both numbers and symbols. Thanks for any help.

noimad1

it might be easier to rename your fields to standard characters?

Sharif

Shoot, I posted the question the wrong way, I mean to say the DATA in the fields:

id|field|
1|asdad|
2|1de|
3|@home|

I want to select rows 2 and 3 because they start with numbers or symbols.

Lars_Berg

where substring(field from 1 for 1)
between '0' and '9'
or substring(field from 1 for 1) in ('@','#', <etc>)

noimad1

Originally posted by Lars Berg

where substring(field from 1 for 1)
between '0' and '9'
or substring(field from 1 for 1) in ('@','#', <etc>)

[/B]

or you may be able to do it backwords so you don't have to define all of those strange characters:

SELECT * FROM YOURTABLE WHERE substring(field from 1 for 1)
NOT BETWEEN 'A' and 'Z' and substring(field from 1 for 1) NOT between 'a' and 'z'

Not sure if that will work or not, but give it a try.

chads2k2

Originally posted by noimad1
or you may be able to do it backwords so you don't have to define all of those strange characters:
SELECT * FROM YOURTABLE WHERE substring(field from 1 for 1)
NOT BETWEEN 'A' and 'Z' and substring(field from 1 for 1) NOT between 'a' and 'z'
Not sure if that will work or not, but give it a try. [/B]

Good call I forgot about that substring function. 🙂 That is why I love reading this fourm! Thanks man!

Chad