Difference between IN and FIND_IN_SET
You may be confused with IN() and FIND_IN_SET() MYSQL functions. There are specific case/situation for both functions where to use which Mysql function. Look at below explanation about IN() and FIND_IN_SET().
IN() : This function is used when you have a list of possible values and a single value in your database.
Example: WHERE memberid IN (1,2,3)
FIND_IN_SET() : This function is used where you have comma separated list of values stored in database and want to see if a certain value exists in that comma seperated list.
Example: WHERE FIND_IN_SET( ‘Bhavin’, namelist )
About The Author
If you want to contact me online then
gTalk : firstname.lastname@example.org
Skype : dreamdesignerx
Yahoo : bhavinrana07
- Php mysql freelancer india fb.me/O0It3HQE# || # 1 month ago
- fb.me/8OXU0O6cN# || # 1 month ago
- Php mysql freelancer india fb.me/OMh4vZ8Y# || # 1 month ago
- Choosing An Effective Web Design Company / Freelancer
- CakePHP – Import a Controller using App::import()
- CodeIgniter – Extending the native ‘Model’ and make it your own.
- Using regular expressions to extract content – php extract texts from html content
- Hardening Your Web Application Against SQL Injections
- PHP Web Development, Custom PHP Development of India based OPS – Instant, Interactive, Inexpensive (freelance php developer programmer wordpress joomla drupal and many open sources, cakephp and many frameworks)
- Google new chart API
- PHP Development India – Best Language for Web Development
- Submit Form Using Ajax (Post)
- Optimizing PHP Through Habits
- Timezones in MySQL and PHP
- How to Hire PHP Programmer for Developing Your Business Site November 30, 2014If you are doing or planning to do an online business then your programmer is the first person who converts your thought into reality. Suppose you have a fantastic online business concept and does not have any web development skill. Then the first thing you do is to hire a web developer to convert your fantastic concept into reality. It is true that we also […]
- Hire PHP Programmer and Get More Than Just Programming October 27, 2014PHP programmers do not just restrict themselves to one area. You need to diversify. One of the most basic things to know is the database management system, MySQL. Most of the jobs you will come across require that you be familiar with what is abbreviated as “LAMP.” These initials stand for Linux, Apache, MySQL as well as PHP. No one will hire PHP programmer […]
- Hire Dedicated PHP Developer for Custom Website Development October 26, 2014Hired PHP Developer provides ideal solutions for your requirements. They provide you with excellent suggestion according to your business specifications. They constantly handle your website daily, so that you can completely focus more on various other business developments. They assist you simply by saving lots of time, money and other resources too. They wi […]
Top Posts & Pages
Follow me On Twitter