A request such as this make me think the database is not properly normalized. If there is one value that can be in several columns, it is very likely those columns need to be broken into their own table, so that they can be queried with a SELECT statement that has only one column in its WHERE clause.
Hope that helps. j----- k----- On Tuesday 11 March 2003 12:30, Paul DuBois wrote: > At 11:01 -0800 3/11/03, Keith Roberts wrote: > >I need to look in several different tables/columns in a database for a > >particular value. If I find it, I need to update it. Is there any way to > >search/update every table/column in one query in a particular database? > > No. mysql, query -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
