Thread: Searching Tables

I have 4 tables for example

firstname | middlename | lastname | phonenumber


Now I am trying to search for multiple entries for example

SELECT * FROM phonenumbers;

I am trying to use SELECT 'not sure what here' FROM phonenumbers;

so that I can find any fields that have multiple information in the phonenumbers field.


      Thanks,
__________________________________<BR>Sent using Valuelinx Webmail System<BR>http://www.valuelinx.net/<BR><BR>Check us
outfor your dial-up and DSL<BR>needs.  And now offering Nationwide Services!<BR>__________________________________ 

On Wed, 2003-08-13 at 13:51, w00t@pop3.valuelinx.net wrote:
> I have 4 tables for example
>
> firstname | middlename | lastname | phonenumber
>
>
> Now I am trying to search for multiple entries for example
>
> SELECT * FROM phonenumbers;
>
> I am trying to use SELECT 'not sure what here' FROM phonenumbers;
>
> so that I can find any fields that have multiple information in the phonenumbers field.

w00t, please be a bit more specific.

--
+---------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net           |
| Jefferson, LA  USA                                            |
|                                                               |
| "Man, I'm pretty.  Hoo Hah!"                                  |
|    Johnny Bravo                                               |
+---------------------------------------------------------------+