Like - problems

Hello there, I was wondering how I could make a specific type of search when the string has more than one word. Ex.- String = "Green Apple" Select * from fruits where (fruits.color like '%Green Apple%' or fruits.type like '%Green Apple%') -

Like question

Hello there, I was wondering how I could make a specific type of search when the string has more than one word. Ex.- String = "Green Apple" Select * from fruits where (fruits.color like '%Green Apple%' or fruits.type like '%Green Apple%') ---

MySQL table design

Hello, I'll try to explain correctly my idea. I need to develop a on-line sale's website. For that, I have some dough's on how to create the table "basket". Client - IDclie (PK) - ... Produts - IDprod (PK) - ... Basket - IDbask (PK) - IDprod (FK) - IDClie (FK) - qt - date Sale

Foreign keys

Hello there, I have a table that with a TEXT filed as a primary key. I can't make a foreign key of this field on another table, why does this happens? Ex: Product --- | ref - text, PK | name - text | ProductsList | ID int, PK | profref - foreign key of the table product | Th