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 11189 May 10, 2002, 9:35 AM
Thread Re: [Andy.] See if field exists?
Wil 11015 May 10, 2002, 9:51 AM
Thread Re: [Wil] See if field exists?
Paul 11010 May 10, 2002, 10:12 AM
Thread Re: [Paul] See if field exists?
Wil 10989 May 10, 2002, 10:53 AM
Thread Re: [Wil] See if field exists?
Paul 11008 May 10, 2002, 11:00 AM
Post Re: [Paul] See if field exists?
Wil 10909 May 10, 2002, 11:09 AM
Thread Re: [Paul] See if field exists?
Wil 11098 May 10, 2002, 11:09 AM
Post Re: [Wil] See if field exists?
Paul 10925 May 10, 2002, 11:19 AM