Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
July 3, 2006, 3:54 am
rate this thread
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
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.
- » MySQL 4.0.17 data scrambles, not-null fields become null, etc.
- — Next thread in » MySQL Database Forum
- » INSERT INTO ... SELECT (...) performance questions
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum