Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
January 26, 2006, 10:54 pm
rate this thread
all the letters a person can click on and will bring up all entries
that start with that letter.
That part is easy:
... WHERE field LIKE '$letter%'
But we'd like to also have one a person can click on for numbers and
Is there a built-in mySQL querey component where you can search for
entries in a column that start with a non-letter?
Thanks for any feedback!
Re: Search for entries starting with a non-letter?
I'd use the regular expression matching predicates implemented in MySQL.
... WHERE someColumn NOT RLIKE '^[[:upper:]]'
See RLIKE in this page:
and reference for regular expression syntax in MySQL in this page:
- » update [table] select - but I only need part of the column field value to select
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum