[SOLVED] REGEXP

[The Little Guy]

How can I do a regular expression?

 

I have tried this:

SELECT * FROM `stats` WHERE REGEXP '^http://phpsnips.com*'

 

but, I get an error.

[JasonLewis]

You need to specify the column on which to perform the Regular Expression on.

 

SELECT * FROM `stats` WHERE `field` REGEXP '^http://phpsnips.com*'

[The Little Guy]

OK Figured it out!

 

Question...

 

How can I take this:

 

SELECT * FROM `stats` WHERE `currentLocation` REGEXP '^http://phpsnips.com*'

 

so it says "where currentLocation !=" what is in the REGEXP?

[JasonLewis]

Try this:

 

SELECT * FROM `stats` WHERE `currentLocation` REGEXP '[^http://phpsnips.com]'

 

Why don't you just use != ?

 

Here is a good reference for MySQL Regex.

[The Little Guy]

Thanks, looks like it worked!

 

I was looking at that like b4

[The Little Guy]

Just kidding, doesn't look like it worked