How to set a field to mirror another field in another table?

I'm a beginner with MySQL so please forgive my clumsy questions. For example, I have a table ALPHA and a table BRAVO. ALPHA has a field called STRING1 I want BRAVO to have a field whose contents would be those of ALPHA.STRING1 How do I define this kind of field, so that the content of BRAVO.BL

RE: How to see whether a field is contained in a string (reverse of LIKE)

>If you are looking for 'Advertising' in the column, >why not just put this in your query > >where SECTOR = 'Advertising' Yes, but instead of 'Advertising' I could have 'Advertising,Media,Whatever' So I need to have a way of finding out whether SECTOR is contained in 'Advertising,Media,Whatever

How to see whether a field is contained in a string (reverse of LIKE)

For example, I have a string "Administration,Advertising,Direction,Media,Research" and I want to see whether a SECTOR field in a row is contained in the above string. so that I can select rows which contain only "Advertising" in their SECTOR field.. sort of like a reverse LIKE, whether a field i