custom mysql Delete query using multi-select

ofb.rielcantalejo

Hello, is there an option on datatables /editor that i can delete specific data using the Delete query of mysql?

for the reason that rows are also associated in other tables by means of inner joins and other data are being used as well.

so my plan is only to delete specific columns by using mysql query so i can list the columns that i want to delete.

For example :

In Displaying Table A

Select a,b,c,d,e form alphabets where code = 123

Upon deleting of rows through multi-select, ill be using a mysql query like :

Delete a,c,e from alphabets where color = blue

This is the multi-select of datatables im using

select: { style: 'multi', selector: ' tr>td:nth-child(4), tr>td:nth-child(5), tr>td:nth-child(6), tr>td:nth-child(7)' }

Thank you very much