[ask] Where clause with many values?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

I want to combine the values80=8B=E2=80=8Bof the two fields are still =
in one table, with the command below :

update kabupaten set id_kabupaten = (
select concat(prop_id, id_kabupaten)
where prop_id = 11

but the above command if prop_id weakness is that I got there 50 000 value,=
 it's not very efficient because I have to type them one by one. Please hel=
p so that commanded more efficient. Thanks b4

Site Timeline