Afficher un message
Vieux 31/10/2007, 15h52   #1
Zouplaz
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut SELECT starting with non letter

Hello, I'm trying to select all the records whose title does not starts
with a letter.

The query

SELECT * FROM bdoc_entries
WHERE (NOT SUBSTRING(titre,1) IN
('a','b','c','d','e','f','g','h','i','j','k','l',' m','n','o','p','q','r','s','t','u','v','w','x','y' ,'z'))

returns only the records starting with a number but forget the ones
starting with something else (space, quotes, ...)

I don't see why...

Thanks
  Réponse avec citation
 
Page generated in 0,05055 seconds with 9 queries