Use RegEx to join

[Christian Schrautzer]

Hi,
in my darabase there are two tables:

parts
id [int(10)]
name [varchar(255)]
info [text]
amount [double]

category
category [varchar(255)]
priority [double]
pattern [text]

In the column 'pattern' there are RegEx patterns defined to specify the categories for the parts. e.g. (.*?screw.*?M6.*?galv.*?) or (.*steel.*?mount.*)

Usually the patterns are executed by program code (searching 'name' & 'info'). Is there a way to use MySql to assign the categories?

Either via some join or by subselect.

Hope there is an idea.

Best regards,
Kevin