CODEWITHSUNDEEP
mysqlregexmysql-regexp
Manikanta
Manikanta

Reputation: 223

[MYSQL][Regular expression] Parsing a string and construct some information from it ini mysql

In a table in my database I have a sentence. I am trying to parse t and construct the categories.

The dimensions of the Item is Height:200, Width:500. And it is in red color.

Height and width can take some standard integers [100, 200, 300, ...]

I want to break parse this sentence and cont how many Items are of height 200 and width 500 and how many are of height 200 and width 300. so on..

I know we have to use regular expression and extract the needed info. I dont have much luck in finding any standard resource on how to parse out this data from the sentence in mysql. In java/any other program language I can do that but sql is not my strength. Any help or pointers is very appreciated.

Upvotes: 0

Views: 49

Answers (0)

Related Questions