D
D
Dima2013-12-24 15:32:12
PHP
Dima, 2013-12-24 15:32:12

regular expression in mysql

Help compose a regular expression for mysql.
I don’t understand regular expressions much, but with the help of function-online dot com I made up such an expression
(?<=[^|\s]).*([a-zA-Z]).*\t.*(\n|$)
in cell A, similar records are stored


Boot: [TAB] Durable synthetic material with water-repellent treatment; synthetic lining; reinforced upper and wider shape increase comfort and provide good foot support; easy care.
Outsole: [TAB] plastic
Blade: [TAB] BOTAS Nicole; certified - European quality certificate T
Gender: [TAB] for women
Sizes: [TAB] 35-43

[TAB] - tabulation.
you need to execute a query where there are Latin characters on the left side of the tab.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2013-12-24
@lucchese

If there is only one TAB in a line, then
[a-zA-z].*\t

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question