Field a: name
B: field experience
Example: such as field content for li wei, a corresponding field b content is li wei to eat watermelon, may also be the content of the corresponding field b is li Ming to eat watermelon, but how to use the SQL query: how much is the whole list name is not contained in the corresponding experience? (the small, small white sincerely ask)
CodePudding user response:
select * from 2019 where experience not like '%' + name + '%'