Will return 0 or false:
SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](8)[[:>:]]"Will return 1 or true:
SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](5)[[:>:]]"For Redshift you must use ~ instead REGEXP on above statements:
| # EditorConfig for web development | |
| # | |
| # EditorConfig | |
| # https://editorconfig.org | |
| # | |
| # Author: Maykonn Welington Candido | |
| root = true | |
| [*] |
| # @author Maykonn Welington Candido <[email protected]> | |
| # For docker-compose for instance you may do it in order to install the latest version on UNIX: | |
| REPO_PATH=docker/compose | |
| ARTIFACT_NAME=docker-compose-$(uname -s)-$(uname -m) | |
| DOCKER_COMPOSE_VERSION=$(curl --silent "https://api.github.com/repos/$REPO_PATH/releases/latest" | grep -Po '"tag_name": "\K.*?(?=")') | |
| sudo curl -L "https://github.com/$REPO_PATH/releases/download/$DOCKER_COMPOSE_VERSION/$ARTIFACT_NAME" -o /usr/local/bin/docker-compose | |
| # Change the REPO_PATH value by the desired repository path | |
| # Change the ARTIFACT_NAME value by the name of the downloadable artifact, you can see the name on the repository release page |
| <?php | |
| // Early fatal errors handler, it will be replaced by a full featured one in Controller class | |
| // (given it does not have any parse or fatal errors of its own) | |
| function earlyFatalErrorHandler($unregister = false) | |
| { | |
| // Functionality for "unregistering" shutdown function | |
| static $unregistered; | |
| if ($unregister) $unregistered = true; | |
| if ($unregistered) return; |
| /** | |
| * Retrieves a customer group hierarchy. | |
| * Change the @root_id value to change the hierarchy root. | |
| */ | |
| SET @root_id = 1; | |
| SELECT * | |
| FROM ( | |
| SELECT * FROM tbl | |
| ORDER BY parent_id, id) hiearchy_sorted, |
| <code_scheme name="maykonn-php-code-style" version="173"> | |
| <PHPCodeStyleSettings> | |
| <option name="CONCAT_SPACES" value="false" /> | |
| </PHPCodeStyleSettings> | |
| <codeStyleSettings language="PHP"> | |
| <option name="SPACE_AFTER_TYPE_CAST" value="true" /> | |
| </codeStyleSettings> | |
| </code_scheme> |
| #!/bin/bash | |
| local_mysql_service=mysql | |
| if (( $(ps -ef | grep -v grep | grep ${local_mysql_service} | wc -l) > 0 )) | |
| then | |
| service ${local_mysql_service} stop | |
| fi | |
| echo "Conflicting local services stopped ($local_mysql_service), continue..." | |
| local_apache_service=apache2 |
| <code_scheme name="Maykonn-Symfony-4-Code-Style" version="173"> | |
| <PHPCodeStyleSettings> | |
| <option name="CONCAT_SPACES" value="false" /> | |
| </PHPCodeStyleSettings> | |
| <codeStyleSettings language="PHP"> | |
| <option name="SPACE_AFTER_TYPE_CAST" value="true" /> | |
| </codeStyleSettings> | |
| </code_scheme> |
Will return 0 or false:
SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](8)[[:>:]]"Will return 1 or true:
SELECT "5,18,5,7,9,2" REGEXP "[[:<:]](5)[[:>:]]"For Redshift you must use ~ instead REGEXP on above statements:
| <?php | |
| /** | |
| * Twitter Integration: Backend endpoint to request token | |
| * | |
| * @author Maykonn Welington Candido<[email protected]> | |
| * @see https://developer.twitter.com/en/docs/basics/authentication/api-reference/request_token | |
| * | |
| * @uses This file must be requested by a application passing the callback_url on querystring. Response Content-Type is application/json. | |
| * @example https://mydomain.com/twitter/request_token.php?callback_url=https://mydomain.com/path-to-redirect-after-request-token | |
| */ |