티스토리 뷰

공부

[python][mysql] c.execute("SELECT * FROM data WHERE params LIKE %s LIMIT 1", ("%" + param + "%",))

승가비 2023. 7. 23. 18:18
728x90

https://stackoverflow.com/questions/10903497/python-mysqldb-where-sql-like

 

Python MySQLdb WHERE SQL LIKE

I have recently started to learn Python and MySQL for web purposes and I have run into a following problem : I want to pull out from a mysql database one record that contains any text that I enter...

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[python] fast api  (0) 2023.07.23
[python] uvicorn  (0) 2023.07.23
[MySQL] MySQL Error 1093 : You can't specify target table 'tablename' for update in FROM clause  (0) 2023.07.23
[aws] instance fleets  (0) 2023.07.22
[MySQL] ALTER TABLE {table} RENAME COLUMN a to b;  (0) 2023.07.22
댓글