how would I be able to query a table to retrieve all strings that contain a lower case character
eq Table A contains Atrribute B and B has values t,T,y,Y
my query should return t,y
eelixduppy
1:14 am on Jul 20, 2006 (gmt 0)
I think you can use MySQL's regex [dev.mysql.com] to achieve this. I don't have much experience with this though.
coopster
4:41 am on Jul 20, 2006 (gmt 0)
Regular expression matching is one thing, returning the values in the matched pattern is another. Different databases will offer different variations, but to the best of my knowledge MySQL does not currently return matched patterns, this is often done by using server-side scripting languages. The entire field value is returned and you then run the value through a regular expression to retrieve subpatterns.
shaan1980
1:56 pm on Jul 20, 2006 (gmt 0)
I'm using Sybase .
syber
4:21 pm on Jul 20, 2006 (gmt 0)
SELECT columnB FROM tableA WHERE ASCII(columnB) > 96
