var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to select titles begin with number
I am trying to find a way to select any record that begins with numbers meaning
I thought using between, but i would have to set the range, but would rather have it just see its a numeral and act accordingly.
select foo from bar where qux regex '^[0-9]'
How could i use this with my current select which is selecting anything LIKE $letter%.
I would like it to Select titles with either numbers or letters but not both.
SELECT * FROM movies WHERE title LIKE $letter% OR title LIKE regex [0-9]
This isnt the correct code, because I am not sure how to implement.
could you please give some examples of titles that do not satisfy these criteria (either numbers or letters)
Originally Posted by thesandman
titles that begin with any letter of the alphabet:
An American Werewolf in London
Any title that begins with numerals like:
1,001 ways to kill a cat
if you go to http://www.rareoopdvds.com/listing.php?letter=e
you will see what I am actually doing.
okay, i understand titles starting with letters
and i understand titles starting with numbers
what i was interested in seeing examples of was titles that satisfied what you said earlier - "I would like it to Select titles with either numbers or letters but not both"
titles that start with letters --
titles that start with numbers --
select foo from bar where qux regexp '^[[:alpha:]]'
titles that start with neither a letter nor a number --
select foo from bar where qux regexp '^[[:digit:]]'
select foo from bar where qux regexp '^[^[:alnum:]]'