However, if you used wildcards you could match as follows :
SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' // Match all addresses at hotmail.com
SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]' // Match all user names beginning with 123@
SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
// Match all users having email address beginning 12 [0-9,a-z, any other character] @ hotmail.com
SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
// Match all users at hotmail.com, hotmail.net, hotmail.biz but *not* hotmail.info
// because ___ (3 underscores) matches any 3 characters but not any 4 characters.
Cheers - Neil.
At 14:45 16/01/2004 +0000, you wrote:
To: [EMAIL PROTECTED]
MIME-Version: 1.0
Message-ID: <[EMAIL PROTECTED]>
From: [EMAIL PROTECTED]
Date: Fri, 16 Jan 2004 14:39:59 +0000
Content-Type: multipart/alternative;
boundary="=_alternative 0050D81280256E1D_="
Subject: MySQL general Question...
What's teh diffence between 'LIKE' & '=' EG: SELECT & FROM my_table WHERE 'email' LIKE '[EMAIL PROTECTED]'
I've just purchased an E-mail marketing piece of software, and was peakign in the code... Found that... Never seen it before (Have I been living in a box?)
Cheers, Tris...
======================================================== CaptionKit http://www.captionkit.com : Production tools for accessible subtitled internet media, transcripts and searchable video. Supports Real Player, Quicktime and Windows Media Player.
VideoChat with friends online, get Freshly Toasted every day at http://www.fresh-toast.net : NetMeeting solutions for a connected world.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php