[RESOLVED] Having trouble with a MySQL LIKE Statement

[experience]

My database can have several products in one column 'Products' e.g. Product1,Product2,Product3

I've created a webpage where the user can purchase a 2nd product at a discounted price - however the 2nd product must be the same Product as a previously ordered product

I'm just stuck on the last part of the SQL query

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1)  AND (Product = @Product) 

Product is the Database Column & @Product is the webpage form checkbox

I want the query to search the database for the customers email where they have paid and the product they have selected matches one they have previously ordered

I've tried

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1)  AND (Product LIKE @Product) 

which half works - if there is only one product in the database - it fails if there is more than one product

So i tried

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1)  AND (Product LIKE '%@Product%') 

However that give me an error when i compile the project saying there is too many arguements in the getdata queries which contain product

da.GetDataByCustomerEmail(CustomerEmail, Product)

Any idea where im going wrong?

[rjv_rnjn]

(Product LIKE '%@Product%')

You are not using the values contained in @Product parameter if you put it inside quotes.

I do not know MySQL but seems like you can try this:

select * from tblUser where Name LIKE CONCAT('%', ? ,'%');

Source: http://dev.mysql.com/doc/refman/4.1/...functions.html

[experience]

Thanks for the link, i tried a couple of variations but get parse errors

WHERE        (CustomerEmail = @CustomerEmail) AND (IsPaid = - 1) LIKE Product ('%', @Product,'%') 

[gep13]

Hello experience,

You seem to have marked the thread resolved, but your last comment makes me think that you are still having problems. Are you?

If not, can you post your final solution?

Gary