[thelist] mysql help

der wert derwert at hotmail.com
Mon Oct 2 00:06:15 CDT 2006

first I would recommend you adding an index field and make it uniq and have 
it auto_increment
now say you have an entry in the table that looks like this

index	= 1
category= misc
url	= http://example.com
title	= example
target	= _blank

if you wanted to change title to example2 you would do the below query

UPDATE `info` SET `title` = 'example2' WHERE `index` = 1 LIMIT 1 ;

The next generation of Search—say hello!  

More information about the thelist mailing list