RE: [PHP-DB] SQL not working !
| From: | Andrew Hill | Date: | Thu, 18 Jan 2001 17:06:56 +0000 |
| Subject: | RE: [PHP-DB] SQL not working ! | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5960@lists.php.net to get a copy of this message | ||
Try,
select first_name from member where home_email1 like '%tvk%' and home_email2
like '%tvk%';
Best regards,
Andrew
----------------------------------------------------
Andrew Hill
Director Technology Evangelism
OpenLink Software
http://www.openlinksw.com
XML & E-Business Infrastructure Technology Provider
> -----Original Message-----
> From: TV Karthick Kumar [mailto:tvkarthick@myrealbox.com]
> Sent: Thursday, January 18, 2001 12:09 PM
> To: php-db@lists.php.net
> Subject: [PHP-DB] SQL not working !
>
>
> Hi
>
> I am working with PHP / Oracle 8
>
> I am a newbie to Oracle and complicated SQL's too.
>
> This is a simple query I wrote and it's not working :
>
> select first_name from member where (home_email1 && home_email2) like
> '%tvk%';
>
> I dont' get any specific errors also !. I think the combination of the
> field names with '&&' it not working. Any help ?.
>
> Thanks in adv.
>
> ~ Karthick
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>