How do I use regular expressions to parse text within SQL commands in Python? [duplicate]

Question

How do I search for a certain text pattern in column data when coding in python using the sqlite3 package?

Do you mean that you can access MySQL with a sqllite3 module? This is new to me — Pullie
– Pullie, Commented Apr 9, 2016 at 20:24
@Pullie: Yes! .... do something like this: import sqlite3 conn = sqlite3.connect('aDB.db') c = conn.cursor() c.execute('SELECT name FROM sqlite_master WHERE type=\'table\'') #list all tables in the database print c.fetchall() c.execute('SELECT sql FROM sqlite_master WHERE type=\'table\' AND name=\'sales\'') #list columns in table 'sales' print c.fetchall() conn.close() — Elle Ameli
– Elle Ameli, Commented Apr 9, 2016 at 20:26
Why are dates allowed to be used in different formats? It would be easier to only allow dates to be one format. — ryanmoir
– ryanmoir, Commented Apr 9, 2016 at 21:05

Community · Accepted Answer · 2017-05-23 12:07:42Z

0

From this question How do I use regex in a SQLite query?

SQLite3 supports the REGEXP operator:

WHERE x REGEXP <regex>

edited May 23, 2017 at 12:07

CommunityBot

11 silver badge

answered Apr 9, 2016 at 22:13

Rumbles

1,4133 gold badges18 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Reti43 Over a year ago

If you felt that a previous answer in its entirety fully answers this question, flagging this as a duplicate might be a better approach than replicating content without bringing anything new on the table.

Rumbles Over a year ago

I already did that, I realised as soon as I posted :)

Collectives™ on Stack Overflow

How do I use regular expressions to parse text within SQL commands in Python? [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related