1 | CREATE TABLE `user_org` ( |
Mysql
User find_in_set
function directly.1
select * from user_org where find_in_set('1003', organizations);
Oracle
- Use
LIKE
key word:1
select * from user_org where organizations like '%1003%';
this may mis match, if element length are not fixed.
- Create a function
1 | CREATE OR REPLACE |