score:2
You can filter with the where-clause
UPDATE myTable
SET *name = REPLACE(*name, 'Tulipa', 'Tulipes')
WHERE *name like 'Tulipa%'
*name = your columnname
score:2
select * from <myTable> where [name(1)] like 'Tulipes%'
Name Country Name(1)
Tulipa Apeldoorn FRA Tulipes Apeldoorn
Tulipa Abba FRA Tulipes Abba
update <myTable> set [name(1)]='your text' where [name(1)] like 'Tulipes%'
More questions
- How update part of record, SQL Server 2008
- SQL Server 2008 : How to update end date column for previous record
- How to: Create trigger for auto update modified date with SQL Server 2008
- How to update sql server timestamp column without changing record data
- How to update a SQL Server table using the latest record
- How to use the original value in a SQL Server update trigger to change a second record
- SQL Server 2008 R2 - UPDATE with SELECT on same table as part of query
- Creating a trigger on SQL Server 2008 R2 to catch a record update
- how to CREATE and UPDATE VIEW in SQL Server 2008 using single query
- How to update the index value in SQL Server 2008
- How to write UPDATE from XML with Table Alias in SQL Server 2008 already have a 'From' statement
- How to update record in SQL Server but only with non null values from parameters?
- How to create a nullable record in SQL Server 2008 R2?
- how to update the varbinary value with null in an image field in sql server 2008
- How to update and insert a new record on when matched condition in SQL Server
- SQL Server 2008 - how to raise error, when trying to update locked row?
- how to update sql tabel with xml data in sql server 2008 using stored procedure
- How to access the previous record in a select statement in SQL Server 2008 R2?
- How to sort record inside views in SQL Server 2008
- how can I Update top 100 records in sql server
- How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
- How to force a SQL Server 2008 database to go Offline
- How do I use the CONCAT function in SQL Server 2008 R2?
- How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- How To change the column order of An Existing Table in SQL Server 2008
- SQL Server 2008 - How do i return a User-Defined Table Type from a Table-Valued Function?
- how to call scalar function in sql server 2008
- How do I connect to a SQL Server 2008 database using JDBC?
- How to view transaction logs in SQL Server 2008
More questions with similar tag
- How to make a query with group_concat in sql server/powerpivot
- Correct mt.exe syntax to resolve pyodbc import problems
- How can I update a table with data retrieved by a join on itself?
- Updating a Type-2 Dimension with the MERGE command
- Checking to see if one or more ids is in a json string
- Get the total sum hours in a column SQL SERVER
- Updating a column when a new row is inserted in sql server
- Update Table Variable in SQL Server and getting Must declare the scalar variable
- Fuzzy grouping in SQL
- Stored Procedure with multi value parameter
- Wrong SQL update query generated on merge
- Syntax error in insert into statement in C# links to MS Access By ADO.NET
- C# SQL Server 'Use <Database>' Required when "Initial Catalog' specified in COnnection String
- Using UPDATE in stored procedure with optional parameters
- Effect of where clause order on SQL query speed
- SQL - Group records by N dollar amount
- Trigger ON Table which fire INSERT into another table which has NOT NULL constraint
- Need to generate n rows based on a value in a column
- Minor change to SQL SERVER query causes extremely slow execution time
- How to select extra columns while using group by clause?
- Distinct with group by in Linq
- Count of col1 over order by col2
- SQL Server - DateTime comparison OverFlows INT value
- SQL Server Insert hangs - blocked by a process
- SQL: Add relations to local temp Declared tables?
- SQL Column data into Array
- Windows application - Just Starting
- What's wrong with this Registration stored procedure
- How do I inject the reliability of machines into my ANN
- PMA-SQL-ERROR while importing database
Source:
stackoverflow.com