Welcome to WebmasterWorld Guest from 54.242.105.196

Forum Moderators: open

MySQL selecting only alnum etc

   
10:34 pm on Jul 23, 2006 (gmt 0)

10+ Year Member



I am trying to create a MYSQL query that selects a title from the table only if that title is made up of the following characters:

a-z A-Z 0-9 hypens spaces underscores

If there is any other kind of character in the title, then the record is not selected.

Something like:
select title from tbl_books where title REGEXP '^[[:alnum:][.space.][.hyphen.][.underscore.]]';

** The above query gives me titles that include commas,periods, etc.

Would you have an idea how I might construct the query?

2:39 am on Jul 24, 2006 (gmt 0)

10+ Year Member



SELECT title FROM tbl_books WHERE NOT title REGEXP '[^a-zA-Z0-9_ -]';

should do it.

[edited by: FalseDawn at 2:40 am (utc) on July 24, 2006]

12:10 pm on Jul 24, 2006 (gmt 0)

10+ Year Member



Thank you FalseDawn, that is close enough! :-)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month