PHP MySQL在列数组中选择数据

Question

If I have a table called 'invitation' like this:

| invitation_id | sender | recipient             |
| 1             | Josh   | James, Hendry, Max    |
| 2             | Steave | James, Gerrard, Ramon |
| 3             | Steave | Gerrard, Max          |

How can I show invitation data that I received, if my name is "James"?

Answer 1

When using like %james% you may get incorrect results, if similar name occurs. So using find_in_set can solve your problem.

select * from invitation where find_in_set('james',recipient) <> 0

You can also use like in this way.

select * from invitation where ',' + recipient + ',' like '%,james,%'