MySQL Help

[SharifTK]

Is there a way to search for records where a fields starts with either a number or symbols such as !,@,#,$,%,&,* ?

[r937]

select yourfield
from yourtable
where yourfield regexp "[^[:alpha:]]"

or something like that, check REGEXP in the manual

[SharifTK]

Well this is the code i have so far for the numbers, can't figure out how to get symbols to work with this though:

SELECT field FROM table WHERE LEFT(field, 1) BETWEEN '0' AND '9'

[r937]

well, if you don't want to look up REGEXP, you could try

where not (lcase(left(field, 1)) between 'a' and 'z')

[SharifTK]

No one said I wasn't going to look . I will soon. Thanks.

[SharifTK]

Ok I am trying to figure it out:

SELECT field FROM table WHERE field = REGEXP [[:alnum:]]+

or

SELECT field FROM table WHERE REGEXP '^!@#$%^&*()1234567890'