insert into same table value where post_title begins like apartments

[dakasadaka]

I want to insert into same table value  1 where post_title begins like apartments

 

I came with this :

 

insert into post (post_categorie_id) values (1) SELECT post_id

FROM post

WHERE post_title LIKE '%Apartments'

 

but doesn't work

any help would be nice

tnx,

daka

[trq]

You need to use an UPDATE statement if you want to update an existing record. Theres also no need for any SELECT subquery.

 

UPDATE post SET post_categorie_id = 1 WHERE post_title LIKE '%Apartments';