Gossamer Forum
Home : General : Databases and SQL :

See if field exists?

Quote Reply
See if field exists?
I know that its just as easy to really easy to just add another SQL: query to check is a certain entry within a table exists, but I was hoping to see if there was a way to see if an entry exists in a specific column when adding something. I.e something you can add to the query, that will stop the addition of it is an identical entry exists.

Could just be wishful thinking here...cois I couldn't find anything about it on mysql.com or other SQL sites Frown

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread See if field exists? Andy 11195 May 10, 2002, 9:35 AM
Thread Re: [Andy.] See if field exists?
Wil 11020 May 10, 2002, 9:51 AM
Thread Re: [Wil] See if field exists?
Paul 11015 May 10, 2002, 10:12 AM
Thread Re: [Paul] See if field exists?
Wil 10994 May 10, 2002, 10:53 AM
Thread Re: [Wil] See if field exists?
Paul 11013 May 10, 2002, 11:00 AM
Post Re: [Paul] See if field exists?
Wil 10914 May 10, 2002, 11:09 AM
Thread Re: [Paul] See if field exists?
Wil 11103 May 10, 2002, 11:09 AM
Post Re: [Wil] See if field exists?
Paul 10930 May 10, 2002, 11:19 AM