Afficher un message
Vieux 18/10/2007, 17h09   #3
Ralf Hüsing
Aucun Avatar
 
Messages: n/a
Hébergeur:
Par défaut Re: finding non-ascii characters within a string

Olav Mørkrid schrieb:
> hello
>
> i would like to search a table column for a range of non-ascii
> characters, or a particular non-ascii character. how can i do this?


Maybe via a inverted regular expression [1] like this?:

SELECT * FROM <TABLE> WHERE <COLUMN> RLIKE '[^-, a-zA-Z0-9]'


[1]: http://dev.mysql.com/doc/refman/5.1/en/regexp.html
  Réponse avec citation
 
Page generated in 0,06170 seconds with 9 queries