Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Re: [Clint] MySQL insert question

Jan 17, 2005, 2:04 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 17, 2005, 2:04 AM
Views: 2212
Shortcut
Quote Reply
Re: [Clint] MySQL insert question In reply to
You could try;

UPDATE lsql_Links SET field_name = '1' WHERE field_name = "Yes"

..and;

UPDATE lsql_Links SET field_name = '0' WHERE field_name = "No"

Hope that helps.

Cheers

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 MySQL insert question Clint 2282 Jan 17, 2005, 1:29 AM
Thread Re: [Clint] MySQL insert question 		Andy 2212 Jan 17, 2005, 2:04 AM
Thread Re: [Andy] MySQL insert question 		Clint 2202 Jan 17, 2005, 2:19 AM
Post Re: [Clint] MySQL insert question 		Andy 2214 Jan 17, 2005, 2:26 AM
Thread Re: [Andy] MySQL insert question 		Clint 2186 Jan 17, 2005, 3:47 AM
Post Re: [Clint] MySQL insert question 		Andy 2213 Jan 17, 2005, 3:53 AM