Insert Into Where Like

[Manat]

Hello All

If I have a field I just added to my table called category, and I want to insert the word 'Pro' into Category to all records where a row called Name is Like %%Pro%%.

Insert Into table field(Category} values(Pro)
Where Name Like %%Pro%%

So all records where Name Like Pro, insert the word Pro into the category field.

Please help me out, i'm using PHPmyAdmin.

THanks

[nnichols]

Just do -

UPDATE table SET Category='Pro' 
WHERE Name LIKE '%Pro%';

Hope this helps 😉