select using LIKE where first character is a integer

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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

Re: select using LIKE where first character is a integer

Quoted text here. Click to load it

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

and this would get you past caring about the irregular leading numeric
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(, LOCATE(' ', )+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

Site Timeline