Member Avatar for bolodski

Hi All,

I've been using the query below to get data that starts with a ',' then any number of spaces in between, then a word

that starts with 'w'...

SELECT * FROM xtable WHERE xvalue REGEXP '(,([[:space:]])*w)'

Using the query above, I was able to get correct results like the following:

1.)aaaa, world <- returns TRUE
2.)bbbb, walk <- returns TRUE

However, there are times that the query also returns TRUE for some data like below:

1.)aaaa, bowl <- also returns TRUE but this doesn't seem to follow the pattern I have set...


I don't know why this returns TRUE, but this is not what I would like to happen(i.e., I want to have case-insensitive

search but the pattern I've set should be strictly followed).

Is this a bug or is this a limitation? And is there a workaround for this?

The version of MySQL I'm using is 5.0.51b.

Thanks to all who will reply,

  • 2 Contributors
  • 1 Reply
  • 53 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by andyhoneycutt
Member Avatar for andyhoneycutt

you might try:

SELECT * FROM xtable WHERE xvalue REGEXP '(,\ w)'

seems to match for me.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.