Regex help needed with MySQL

[golfwebuk]

Hi Guys!

 

I have created a search form in PHP and the user has the ability to select "Exclude hyphens" and "Exclude numbers" from search options.  When they select Exlude hyphens for example, the search should return only rows that DO NOT contain hyphens.  The same applies for numbers.

 

I am trying something like this, but to no avail.

 

select * from domains where domain NOT LIKE '^[0-9]+$'

 

Please help 

[Ken2k7]

Try REGEXP - http://dev.mysql.com/doc/refman/5.1/en/regexp.html

[golfwebuk]

Try REGEXP - http://dev.mysql.com/doc/refman/5.1/en/regexp.html

 

Thanks, but I have also tried the following to no avail.

 

select * from domains where domain NOT REGEX '^[0-9]+$'

[Ken2k7]

It's REGEXP, not REGEX.

 

Your regexp doesn't do what you want. You wanted a regexp that returns results that doesn't match it. Your regexp is for a string of numbers and numbers only.

 

SELECT * FROM domains WHERE domain REGEXP '[^0-9]';

[golfwebuk]

Thank you.