On 20-Mar-01 John Nielsen wrote:
> Hi Everyone,
>
> This question may have been asked before, but i could not find it in the
> archives, so i was wondering if someone could help me out.
>
> Say i had the following table:
>
>
> +----+----------------------------+-------------+
>| id | address | domainalias |
> +----+----------------------------+-------------+
>| 2 | [EMAIL PROTECTED] | fred |
>| 3 | [EMAIL PROTECTED] | bill |
> +----+----------------------------+-------------+
>
>
> Now say i had over 200 entrys in that table, but all i wanted to see was
> just "[EMAIL PROTECTED]" but i did not know what "id" it was, is there a
> way i can "search" the table, and only show the relevent information that
> i need?
>
select * from da_table where address='[EMAIL PROTECTED]';
Regards,
--
Don Read [EMAIL PROTECTED]
-- If you are going to sin, sin against God, not the bureaucracy.
God will forgive you but the bureaucrats won't.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php