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 11264 May 10, 2002, 9:35 AM
Thread Re: [Andy.] See if field exists?
Wil 11082 May 10, 2002, 9:51 AM
Thread Re: [Wil] See if field exists?
Paul 11077 May 10, 2002, 10:12 AM
Thread Re: [Paul] See if field exists?
Wil 11056 May 10, 2002, 10:53 AM
Thread Re: [Wil] See if field exists?
Paul 11075 May 10, 2002, 11:00 AM
Post Re: [Paul] See if field exists?
Wil 10976 May 10, 2002, 11:09 AM
Thread Re: [Paul] See if field exists?
Wil 11165 May 10, 2002, 11:09 AM
Post Re: [Wil] See if field exists?
Paul 10992 May 10, 2002, 11:19 AM