How to match python strings similar to like in mysql

Question

a = "This is some text"
b = "This text"

I want to compare the variable b in a and should return true even if the text contains more than two words like

a = "This is another text here"
b = "This another here"

even if I compare b in a should return true in python

Condition: True == All words in b found, the same order, in a.
In the above examples, the words have to be in the same order and upper/lowercase.

Possible duplicate of [Python String Formats with SQL Wildcards and LIKE](https://stackoverflow.com/questions/3134691/python-string-formats-with-sql-wildcards-and-like) — Rahul Agarwal, Sep 14 '18 at 10:45

Chandu · Answer 1 · 2018-09-14T10:19:12.260

1

a = "This is some text"
b = "This text"

c = 0 
for i in b.split(): # check for each word in a
    if i in a: c = c + 1 # if found increases the count
c>=2 # true

or

len([value for value in a.split() if value in a.split()]) >= 2

edited Sep 14 '18 at 10:19

answered Sep 14 '18 at 10:16

Chandu

2,053
3
25
39

i want it in regular expression. similar to like in mysql – Shanmukha Vj Sep 14 '18 at 10:18

score 0 · Answer 2 · answered Sep 14 '18 at 12:22

You can mimic the behavior to a certain extent using regex.

import re

def is_like(text,pattern):
    if '%' in pattern:
        pattern = pattern.replace('%','.*?')
    if re.match(pattern,text):
        return True
    return False


a = "This is another text here"
b = "This%another%here"
print(is_like(a,b))
>>>>True
a = "Thisis sometext"
b = "This % text"
print(is_like(a,b))
>>>>False
a = "Thisis sometext"
b = "This%text"
print(is_like(a,b))
>>>>True
a = "This is some text"
b = "This text"
print(is_like(a,b))
>>>>False

Note that I have not implemented any escaping for % character, so searching for % won't work.

How to match python strings similar to like in mysql

2 Answers2