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 WHERE RLIKE '[^-, a-zA-Z0-9]'
[1]: http://dev.mysql.c
Hi,
Olav Mørkrid wrote:
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?
the column can be any string like "hello, world" or "norwegian
characters æøå here".
refer to these pseudo examples:
SELECT * FROM
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?
the column can be any string like "hello, world" or "norwegian
characters æøå here".
refer to these pseudo examples:
SELECT * FROM TABLE WHERE COLUMN CONTAINS