var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: help with MySQL dynamic sql
I am developing C# winForm application. I have a textbox for searchign customer name but I want the user to enter the customer name like this:
then in MySQL I want to have a dynamic sql to search search the customer_name like this:
SELECT * FROM customers WHERE customer_name CONTAINS john AND customer_name CONTAINS mathews
what you're aiming for is
WHERE customer_name LIKE '%john%'
AND customer_name LIKE '%mathews%'