select using LIKE where first character is a integer

[coolvixs]

hi,

i have some data in mysql in a column like this:
6.1.01 Financial Regulations
3.32.02 Academic Counseling

what iam selecting is select by letter A, B, C...Z. so my first char in
the column is always a integer, how can i select when the first few
characters are always a integer, i want to get rid of the integers and
run query on the word when selecting.

would greatly appreciate someone's help on this

[Thomas Bartkus]

<co******@gmail.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

hi,

i have some data in mysql in a column like this:
6.1.01 Financial Regulations
3.32.02 Academic Counseling

what iam selecting is select by letter A, B, C...Z. so my first char in
the column is always a integer, how can i select when the first few
characters are always a integer, i want to get rid of the integers and
run query on the word when selecting.

would greatly appreciate someone's help on this

Given these circumstances, it would probably be smarter to match on a more
complete string rather than just the first letter. You could use:
{fld} LIKE '%Financial %'
or
{fld} LIKE '%Academic %"

and this would get you past caring about the irregular leading numeric
digits.
OR
you might take advantage of the fact that the string you are looking for
begins just after the blank space " " that follows the number.

WHERE MID({fld}, LOCATE(' ', {fld})+1, 1) = 'A'

LOCATE() finds the first blank space and MID() shows you the string starting
with the first alpahabetic character that follows.

I like the first solution because it identifies the string more explicitly.
Thomas Bartkus

[pinguinu]

hy
try this

select * from barcode
where (SUBSTR(barcode, 1, 1) not between '0' and '9')
or (SUBSTR(barcode, 2, 1) not between '0' and '9')
or (SUBSTR(barcode, 3, 1) not between '0' and '9')