{"id":232,"date":"2013-10-31T04:57:53","date_gmt":"2013-10-31T04:57:53","guid":{"rendered":"http:\/\/www.advancedwebhelp.com\/blog\/?p=232"},"modified":"2013-11-02T05:09:09","modified_gmt":"2013-11-02T05:09:09","slug":"2-great-mysql-conditionals","status":"publish","type":"post","link":"https:\/\/www.advancedwebhelp.com\/blog\/2013\/2-great-mysql-conditionals","title":{"rendered":"Using REGEXP in mySQL WHERE Conditionals"},"content":{"rendered":"
\n

\"SQL<\/a>Recently, I needed a MySQL conditionals that I had not used previously. \u00a0 I needed to add a condition that included an OR condition on a single field.\u00a0 While OR<\/strong> is available in the WHERE conditional, it along with the LIKE filter overly complicated my query. \u00a0 Some OR conditionals become very complicated with the OR conditional.\u00a0 I found that the MySQL function REGEXP<\/strong> was just what the doctor ordered.\u00a0\u00a0 It opened up a wide variety of options, and simplified the query.<\/p>\n

Using REGEXP\u00a0 turned out to be not only easy, but, convenient. We can use regular expressions.\u00a0 If you are used to using regexp, you will love this feature. For example, assume you have fields called`price` and `view` and you want to find records with the price under $300,000 and a `view` of ‘ocean,’ ‘river,’ or ‘lake,’ you can use regular expressions. You may use the following SQL conditional:<\/p>\n

WHERE `price` < 400000 AND `view` REGEXP ‘Ocean|River|Lake’<\/p>\n

As with other places you can use regexp, this allows you to say you would like the field `view` to contain the Ocean, River or Lake … regardless of whatever else is in that field.\u00a0\u00a0 Therefore, it references the field once and incorporates the concept of LIKE.<\/p>\n

Of course, you could request the field to contain:<\/p>\n