Member Avatar for chupacabra

python 2.4.1
mySQLdb 1.2.0
kernel 2.6.12

Hi,

How can I make the following statement so I can search for any string?

Right now I need to input at runtime %whatever I'm looking for% between % signs to get all records matching that query.

I want to have this statement set up so I do _not_ have to type the % at runtime.

This is what I have...

cursor.execute('select * from someTable where s_about like %s', (searchWhat))

any idea on how to achieve this?

el chupacabra

  • 3 Contributors
  • 2 Replies
  • 134 Views
  • 1 Year Discussion Span
  • Latest Post Latest Post by locosway
Member Avatar for vegaseat

Not all of us are familiar with the mySQLdb module. Can you give us a little more info?

Member Avatar for locosway

The problem is in your syntax. You need to join the strings together, an easy way to do this is:

cursor.execute('select * from someTable where s_about like ' + variable + ';')
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.