Skip to content

iyzl/MySql-REGEXP

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

8 Commits
 
 

Repository files navigation

for Mysql;

create;

CREATE TABLE _text ( ID int(11) NOT NULL AUTO_INCREMENT, DATA text PRIMARY KEY (ID) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

data;

ID : 5 DATA : [{"ID":"3292"},{"ID":"278"},{"ID":"2410"},{"ID":"368"},{"ID":"3094"},{"ID":"2980"},{"ID":"2904"},{"ID":"2914"}]

ID : 6 DATA : [{"ID":"3291"},{"ID":"279"},{"ID":"2110"},{"ID":"1368"},{"ID":"3194"},{"ID":"1980"},{"ID":"1904"},{"ID":"1914"}]

query;

SELECT * FROM TABLENAME WHERE TABLENAME.COLUMN REGEXP '[[:<:]]2410[[:>:]]' LIMIT 1;

result;

ID : 5

Releases

No releases published

Packages

No packages published