This post explains how to search for multiple strings in MySQL without using the In MySQL, the Example:<\/strong><\/p>\n\n\n\n However, searching for multiple values directly like the following is not possible:<\/p>\n\n\n\n If we want to search for multiple values using Using this format can become difficult to implement in multiple places. The following approach provides a simple way to search for multiple values without using the Before implementing the query, you should have:<\/p>\n\n\n\n The following MySQL query can be used to search for multiple values without using the Here, the For example:<\/p>\n\n\n\n means that the query searches for With The alternative query avoids repeating This can make the query easier to construct when multiple values need to be searched.<\/p>\n\n\n\n If the search values are available as an array in PHP, the query can be constructed dynamically.<\/p>\n\n\n\n Assume the following array values:<\/p>\n\n\n\n The query can be generated using the following code:<\/p>\n\n\n\n The PHP code loops through the array values and adds each value to the SQL query using an Finally, the generated query will look similar to:<\/p>\n\n\n\n After the query is generated, it can be executed to retrieve the matching results.<\/p>\n\n\n\n MySQL’s Using No. Multiple values generally require separate You can use Yes. PHP arrays can be processed using a loop to construct multiple SQL conditions dynamically.<\/p>\n\n\n\n Learn how to change the WordPress site URL directly from the MySQL\/MariaDB database when the site URL needs to be updated from the backend.<\/p>\n\n\n\n Change WordPress Site URL Backend Using MySQL\/MariaDB<\/a><\/p>\n\n\n\n This article provides another reference for working with MySQL MySQL FIND_IN_SET Multiple Search Strings<\/a><\/p>\n\n\n\nFIND_IN_SET()<\/code><\/strong> function.<\/p>\n\n\n\nFIND_IN_SET()<\/code> function can be used to search for a single string within a comma-separated list.<\/p>\n\n\n\nfind_in_set('a','a,b,c,d')<\/pre>\n\n\n\nfind_in_set('a,b,c,d','a,b,c,d')<\/pre>\n\n\n\nFIND_IN_SET()<\/code>, we need to use multiple conditions:<\/p>\n\n\n\nfind_in_set('a', 'a,b,c,d') OR find_in_set('b', 'a,b,c,d') OR find_in_set('c', 'a,b,c,d')<\/pre>\n\n\n\nFIND_IN_SET()<\/code> function.<\/p>\n\n\n\nPrerequisites<\/h2>\n\n\n\n
\n
Implementation<\/h2>\n\n\n\n
Step 1: Search Multiple Values Using MySQL<\/h3>\n\n\n\n
FIND_IN_SET()<\/code> function:<\/p>\n\n\n\nSELECT * from table_name WHERE CONCAT(\",\", `id`, \",\") REGEXP \",(1|2|3),\"<\/pre>\n\n\n\n
REGEXP<\/code> expression allows multiple values to be specified using the |<\/code> operator.<\/p>\n\n\n\n1|2|3<\/pre>\n\n\n\n
1<\/code>, 2<\/code>, or 3<\/code>.<\/p>\n\n\n\nStep 2: Using FIND_IN_SET() for Comparison<\/h3>\n\n\n\n
FIND_IN_SET()<\/code>, multiple search values would require separate conditions:<\/p>\n\n\n\nfind_in_set('a', 'a,b,c,d') OR find_in_set('b', 'a,b,c,d') OR find_in_set('c', 'a,b,c,d')<\/pre>\n\n\n\nFIND_IN_SET()<\/code> for every search value:<\/p>\n\n\n\nSELECT * from table_name WHERE CONCAT(\",\", `id`, \",\") REGEXP \",(1|2|3),\"<\/pre>\n\n\n\n
PHP with MySQL Without FIND_IN_SET()<\/h3>\n\n\n\n
Example<\/h3>\n\n\n\n
$a=array(10,12,13,14,15);<\/pre>\n\n\n\n
<?php\n\n$a=array(10,12,13,14,15);\n$test=\"SELECT * from table_name WHERE\";\n$tot=count($a);\n$counter=1;\nforeach($a as $val)\n{\n echo $counter;\n $test .= \" id=$val\";\n if($counter !=$tot)\n {\n $test .=\" OR \";\n }\n $counter++;\n} \necho $test;\n mysql_query($test); ?><\/pre>\n\n\n\nOR<\/code> condition.<\/p>\n\n\n\nSELECT * from table_name WHERE id= 10 OR id = 12 OR id= 13 ...<\/pre>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
FIND_IN_SET()<\/code> function is useful for searching a single value in a comma-separated list, but searching multiple values can require multiple FIND_IN_SET()<\/code> conditions.<\/p>\n\n\n\nCONCAT()<\/code> with REGEXP<\/code> provides another approach for searching multiple values, while PHP can be used to dynamically build an SQL query when the values are available in an array.<\/p>\n\n\n\nFAQs<\/h2>\n\n\n\n
What is
FIND_IN_SET()<\/code> in MySQL?<\/h4>\n\n\n\nFIND_IN_SET()<\/code> is a MySQL function used to search for a string within a comma-separated list of values.<\/p>\n\n\n\nCan
FIND_IN_SET()<\/code> search multiple values directly?<\/h4>\n\n\n\nFIND_IN_SET()<\/code> conditions connected using operators such as OR<\/code>.<\/p>\n\n\n\nHow can I search multiple values without
FIND_IN_SET()<\/code>?<\/h4>\n\n\n\nCONCAT()<\/code> “together with” REGEXP<\/code> to match multiple values in the query.<\/p>\n\n\n\nCan PHP arrays be used to build a MySQL query?<\/h4>\n\n\n\n
Why use
REGEXP<\/code> multiple search values?<\/h4>\n\n\n\nREGEXP<\/code> allows multiple matching alternatives to be specified using the |<\/code> operator, making it possible to search for several values in a single expression.<\/p>\n\n\n\nRelated Articles<\/h2>\n\n\n\n
Change WordPress Site URL from Backend Using MySQL\/MariaDB<\/h4>\n\n\n\n
MySQL FIND_IN_SET with Multiple Search Strings<\/h4>\n\n\n\n
FIND_IN_SET()<\/code> and handling multiple search strings.<\/p>\n\n\n\nTalk to our experts<\/h2>\n\n\n\n