Live Chat
True
FAQs
Technical

update database using LIKE

example to use like 


update account_move_line set account_id='45' where "move_name" like '%STMQ3%'  and account_id='48' 



that mean update table name account_move_line  to set new value for column name account_id to set new value 45 

where 2 conditions to filyer table  ===> first condition  move_name column contain name like STMQ3

                                                            and second condition is column account_id=48


Was this article helpful?

FAQ HOME

To install this Web App in your iPhone/iPad press and then Add to Home Screen.