Archivio per Novembre 2017

Mysql update with replace and select

26 Novembre 2017 Nessun commento
1 Star2 Stars3 Stars4 Stars5 Stars (Ancora nessun voto)

Today, the my lesson speaks of mysql query (update partial of parameter and select).
Query of select:
SELECT field FROM `table` WHERE field LIKE ‘%text%’
use % for select a partial text of field

Query of update:
UPDATE `table` SET field = REPLACE(field,”text1″,”text2″)
text 1 is a partial text to you replace into field of text with text 2