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

Or you could just reverse the arguments to LIKE, so your field is on the right and your string is on the left. You may have to surround your field with concat('%', field_name, '%') (or just use regexp), but LIKE is a binary string comparison operator and doesn't care which, if either, arguments a

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

On 14 Oct 2002, at 20:29, Tim Kerch wrote: > 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. You could construct a query something like this: SELECT * FROM table_name W

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

On Monday, Oct 14, 2002, at 13:29 America/Phoenix, Tim Kerch wrote: > 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 "Adver

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