[an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] (none) [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive][an error occurred while processing this directive]
 
[an error occurred while processing this directive] [an error occurred while processing this directive]
Skåne Sjælland Linux User Group - http://www.sslug.dk Home   Subscribe   Mail Archive   Forum   Calendar   Search
MhonArc Date: [Date Prev] [Date Index] [Date Next]   Thread: [Date Prev] [Thread Index] [Date Next]   MhonArc
 

Re: [PROGRAMMERING] [SQL] Erstatning af indhold i felter



UPDATE `tabel` SET `felt` = '....'WHERE (en eller anden kondition)

Kunne være at LIKE ku' bruges:
UPDATE `tabel` SET `felt` = '..' WHERE felt like 'http://dom%';

'%' (procent-tegn er wild-card-tegn i SQL) og
'like' bruges i stedet for '=' når der anvendes wild-card

-- 

Virtually

Niels Muller Larsen
MSc Networked Information Engineering

Erhvervsakademiet Århus Købmandsskole
Sønderhøj 30
DK8260 Viby J

Phone: +45 8936 3317
Mobile: +45 2040 5740
Web: http://x15.dk
Public key: 0xD4DB4A5E


 
Home   Subscribe   Mail Archive   Index   Calendar   Search

 
 
Questions about the web-pages to <www_admin>. Last modified 2005-08-10, 22:44 CEST [an error occurred while processing this directive]
This page is maintained by [an error occurred while processing this directive]MHonArc [an error occurred while processing this directive] # [an error occurred while processing this directive] *