over 8 years ago
In some cases, we use find_in_set() instead of in() in mysql. Following is an example, where we should use find_in_set() instead of in() :-
Suppose we have a table 'flashdata':-
fid productId 1 75,73 2 72 3 71, 73
Now, if we want to get all fid that have productId is 73 then our query should be:-
select fid from flashdata where find_in_set(73, productId);
it returns fid 1 and 3
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Sign up using
0 Comment(s)