Forum Moderators: open
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?