Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query special character
On 21 Jul 2001 00:43:47 -0700, tuan.tran_at_verizon.net (Tuan Tran) wrote:
> Please help.
> I having problem with @ special character in my database.
>
> when I do a select statement in sqlplus
> select * from subscribers
> where email = 'johndoe_at_yahoo.com';
> I got no rows selected from the server.
>
> but if I do
> select * from subscribers
> where email like 'johndoe%';
My immidiate reaction to this is that you are using Perl. Not? Remember that Perl will interpolate @yahoo with whatever the array contains if the string is double quoted. Try using single quoted sql-strings, or even better: use bind and :1, :2 and so on.
> then the server returned:
> EMAIL
> --------------------------------------------------
> johndoe_at_yahoo.com
>
> is there a way where I can do the first query (select * from
> subscribers where email = 'johndoe_at_yahoo.com' ) and get the record
> back?
>
> Thanks in advance.
Received on Sun Jul 22 2001 - 21:29:36 CDT